-
xml File
Can xml files be parsed and inserted into tables in Oracle.
-
theres an XMLType column in Oracle 9i, if the column is defined as XMLTYpe u can insert the XML documents into it...
-
this shuld work....
create table XMLTable (ord_id number, xml_data XMLType);
insert into XMLTable values (1,
XMLType('
1
- saddfdass
'));
-
sorry didnt print properly in my last post...
PHP Code:
insert into XMLTable values (1,
PHP Code:
XMLType('<ORDERDETAILS>
PHP Code:
<ORDNO>1</ORDNO>
PHP Code:
<ITEM>saddfdass</ITEM>
PHP Code:
</ORDERDETAILS>'));
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|