| How ILoading .xml into target table [message #301519] |
Wed, 20 February 2008 23:23 |
someswar1
Messages: 53
Registered: January 2008
|
Member |
|
|
Hi,
I have emp.xml file which consist of emp table field. I want to load that xml file to target table(semp which is create table semp as select *from emp where 1=2).
To load this xml file i am written procedure to load xml file in emp_xml table( create table emp_xml col1 sys.xmltype) and extract the field from emp_xml table and load to semp table.
Can anyone tell me how i load this xml file to semp table without storing the emp_xml table. that means a procedure which take input one directory name, and xml file name in run time and load the xml file into a semp table;
regards:
someswar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
