How can I use dynamic SQL column names in a Merge/Insert statement in Oracle?

edit

To use dynamic SQL column names in a Merge/Insert statement in Oracle, you can follow the below steps:

1. Write a SQL query to generate the dynamic column names, for example:

SELECT column_name
FROM all_tab_columns
WHERE table_name = 'table_name'
AND column_id > 3;

1. Use the above SQL query in a PL/SQL block to generate the column names as a string:

DECLARE 
   col_names VARCHAR2(200);
BEGIN
   SELECT LISTAGG(column_name,',') WITHIN GROUP (ORDER BY column_id)
   INTO col_names
   FROM all_tab_columns
   WHERE table_name = 'table_name'
   AND column_id > 3;
END;

1. Use the generated column names in the Merge/Insert statement as follows:

MERGE INTO table_name t
USING (
   SELECT value1, value2, value3, ...
   FROM source_table
) s
ON (t.key_column = s.key_column)
WHEN MATCHED THEN 
UPDATE SET 
   t.column1 = s.column1,
   t.column2 = s.column2,
   ...
   t.columnN = s.columnN
WHEN NOT MATCHED THEN
INSERT (key_column, col_names)
VALUES (s.key_column, s.value1, s.value2, s.value3, ..., s.valueN);