How to get IF THEN ELSE condition from another table
Hi eveybody,
I have one situation and i need your advice guys.
I have to apply IF THEN ELSE condition in PL/SQL from some other table. I am doing merging in tableA which will execute IF column1 from tableC = Y.
E.g: Tablec has three columns:source, dest, condition. IF condition = Y in tableC, Then merge into tableA using (Sql query selecting from source in table C) B.
Please let me know how to get condition = Y from table C.
IF condition = Y for respective source in C, then merge will happen for that source.
Please provide your comments and responses.
I will really appreciate your comments and responses.
Thank you very much.