I am using below code to insert data into a table by fetching data from another table.
insert into tab1(id,name)
select id,name from tab1_X;
But suppose due to any issue one or more insert fails, then I need to log that error in my custom error log table and also need to execute next insert i.e., insertion of other rows should not stop on failure of any one.
Can anyone please help in this.
I am using Oracle 10g database.