Loading Data From XML file to SQL database

Knowledge modules: LKM SQL and IKM SQL Control Append or incremental update.

Generating XML data file using SQL.

SELECT DBMS_XMLGEN.GETXML('select * from emp') FROM DUAL;