xml File

[joe_kk]

Can xml files be parsed and inserted into tables in Oracle.

[Srinivas_Sharma]

theres an XMLType column in Oracle 9i, if the column is defined as XMLTYpe u can insert the XML documents into it...

[Srinivas_Sharma]

this shuld work....

create table XMLTable (ord_id number, xml_data XMLType);

insert into XMLTable values (1,
XMLType('

1
saddfdass

'));

[Srinivas_Sharma]

sorry didnt print properly in my last post...

insert into XMLTable values (1, 

XMLType('<ORDERDETAILS> 

<ORDER> 

<ORDNO>1</ORDNO> 

<ITEM>saddfdass</ITEM> 

</ORDER> 

</ORDERDETAILS>'));