Say, Table A01 has 100 records in 5 columns, col1, col2, col3, col4, col5 The datatype are varchar2, date, number etc. (No clob or blob)
Table B01 has same columns and datatype as A01. Via a procedure, Table B01 is truncated and it gets new vales when the procedure executes.
These vales from B01 are to be inserted into A01 WITHOUT Creating any duplicate records in A01. In other words, a record gets inserted into A01 ONLY IF no value in any of the columns already exist in table A01.
How would you do that?
Thanks a lot.