Create table using the first row as column names then insert data
Hi,
Currently I have an application where the user can load the data based on predefined standard template, I am trying to help the user, in way that if the column headers in the first row matches the table column names then load data, the order of the columns in the loading file may be in any order, the data should be inserted to the corresponding table columns.
Could anyone please help me in creating table using the first row as table column names, for the file in: p7_x (File upload)
The number of columns in the file and the table should be in sink
Regards,
Rajesh.