I posted before about storing physical XML files in Database Table, You can read it from Here
Today I want to generate XML file from database based on certain query, then store XML file in database table.
First, I will create table to store employees XML files
Today I want to generate XML file from database based on certain query, then store XML file in database table.
First, I will create table to store employees XML files
CREATE TABLE EMP_XML
(
EMPNO NUMBER,
EMP_XML_FILE XMLTYPE
);