plsql scenario based interview questions
NTO target_table (col1, col2) VALUES (rec.col1, rec.col2); EXCEPTION WHEN DUP_VAL_ON_INDEX THEN INSERT INTO error_log (record_id, error_message, error_time) VALUES (rec.id, 'Duplicate Value', SYSDATE); WHEN OTHERS
