Because I am tried of typing so long merge commands. This is more simple: V_RESULT := F_MERGE ( 'select * from PERSON@old_db' ,'PERSON', 'ID' ); for L_I in 1..V_RESULT.count loop dbms_output.put_line( ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Ludi Akue discusses how the tech sector’s ...
Uses SQLBulkCopy to copy data from a table or view in the source database to a temporary table in the target database before running SQL MERGE from the temporary table to the destination table. This ...
Any chance you can post the sql CREATE TABLE scripts for the tables and fields in question (obscufated if you like)? it would make things a bit easier I think. Also, the specific DBMS would be helpful ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results