I'm using PL/SQL developer using 11g.
My problem: I have a table that contains new records 'load_customer_data' and I've compared them to another table 'customer_data'. I've determined what do to when there is a match or if there isn't by a field called 'what_to_do'. in that field it says if I should update a record in 'customer_data' from 'load_customer_data' or insert a record from 'load_customer_data' into 'customer_data' and if the records are the same in both tables to say its an exception.
a merge statement would take care of the update or insert but I can't think of a way to say if 'what_to_do' = 'exception' then insert it into 'customer_data_exceptions'
my manager said use and else if statement but I can't seem to get that to work neither.