oracle condition in where clause

Question

User-583959464 posted

how can i add condition in where clause. can i use "case when" in the where clause to update record.

update table_name set col_1=99 where col_2=xx and col_3=yy and (case when col_4 = '01' then '02'

                                                                                                                      when "02" then "03" when "04" then "05")

that mean when col_4=01 then the condition is to retrieve record col_4="02" to update.

or other better way to do that. any example for me.

Answer 1

User269602965 posted

you left out the left side of the equals comparison

and col4 = (condition phrase be it CASE or DECODE)