Oracle SQL Adding IF statement

Question

I have a pretty simple question me thinks. I've been looking on the internet, but haven't been able to find anything. I am trying to add an IF statement basically to my Oracle sql.

UPDATE PS_Z_TREND_NOW_TBL a 
  SET STATUS = ( 
 SELECT COUNT(SEC.IS_AW_AUTH_NAME) 
  FROM PS_IS_AW_SECURITY sec 
 WHERE sec.IS_AW_AUTH_NAME LIKE '%Manager%'

I want to update STATUS so that if COUNT(SEC.IS_AW_AUTH_NAME) is greater than 0 it will insert 'M'. How would I write this?

Are you sure that you want PS_Z_TREND_NOW_TBL updated for all records if the COUNT(SEC.IS_AW_AUTH_NAME) is greater than 0? Could it be that you want this done only when a.is_aw_auth_name = sec.is_aw_auth_name. Could it be that you want to use a correlated subquery in your where clause or merge statement? — Patrick Bacon
– Patrick Bacon, Commented Sep 30, 2014 at 21:19

crthompson · Accepted Answer · 2014-09-30 20:55:55Z

3

With Case statements.

UPDATE PS_Z_TREND_NOW_TBL a 
  SET STATUS = ( CASE WHEN COUNT(SEC.IS_AW_AUTH_NAME)  > 0 then 'M'
                 ELSE null END )
FROM PS_IS_AW_SECURITY sec 
WHERE sec.IS_AW_AUTH_NAME LIKE '%Manager%'

answered Sep 30, 2014 at 20:55

crthompson

15.9k6 gold badges64 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Oracle SQL Adding IF statement

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related