-
How to read XML Data stored as Clob
An XML data has been dumped into a Clob field in a Oracle Table.
SQL> desc XML_TEST1
Name Null? Type
----------------------------------------- -------- -------
XMLTEST CLOB
How do we read the data in sqlplus.
Any examples will be of much help.
I am a XML newbee.
-
-
Read like any other tables.
I want to populate the data into a normal table.
-
Hi
How do you want to populate the other table.
If the first table stores the xml in clob do you want to shred the xml into relational when you store it into table B ?
regards
Hrishy
-
Yes.I want to read the clob and move the data to another table.
-
Hi
When you the data to another table in another table will it be stored in relational format or in clob ?
post a small example here.
regards
Hrishy
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
|