Skip to content
Advertisement

How to use Update command with CASE statement in Oracle?

I have to update the Matching Flag Column depending on the following Condition :

When F_ZN=IC_ZN AND F_STN=IC_STN then Matching Flag would be set to 1 else 0 ,I could think of this but I don’t know the exact syntax .

Schema of F_STATE_MAPPING Table is

Please guide .

Advertisement

Answer

You about using exists?

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement