@table_name varchar(776), -- The table/view for which the MERGE statement will be generated using the existing data @target_table varchar(776) = NULL, -- Use this parameter to specify a different ...

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( ...

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 ...

EnterpriseDB (EDB), a provider accelerating Postgres in the enterprise, is adding a series of contributions to PostgreSQL 15, which is now globally available, marking the introduction of the MERGE SQL ...