| Can someone help me [message #124514] |
Sun, 19 June 2005 18:52 |
new2ora
Messages: 1
Registered: June 2005
Location: india
|
Junior Member |
|
|
Hi Gurus,
I'm a newbie to oracle , can someone pls help me. Here is my problem.
Problem:
I've a clob feild from which I've to extract data and load it into another table.The structure of my xml in the clob is as follows.
xml version = '1.0' encoding = 'UTF-8'
innertable
row index = '1'
column name = 'ITEM' value = '11
column name = 'CODE' value = 'aa'
column name = 'DESC' value = 'desc'
column name = 'QUANTITY' value = '2'
column name = 'PRICE' value = '23'
column name = 'COST' value = '16'
/row
row index = '2'
column name = 'LINE' value = '22'
column name = 'CODE' value = 'bb'
column name = 'DESC' value = 'desc'
column name = 'QUANTITY' value = '2'
column name = 'PRICE' value = '11'
column name = 'COST' value = '20'
/row
innertable
The target table has all the columns( line,code,desc,quantity,price,cost) and i've to just load the values from the above xml(which is clob)
EX: if the above xml is loaded into my target table, it should have the following rows
11 aa desc 2 23 16
22 bb desc 2 11 20
Can someone please provide me an example/procedure of how to acheive this. And this should be done in Pl/SQL only and I'm using Oracle9i.
NOTE: I'VE REMOVED THE CLOSING AND OPENING BRACES OF THE XML TAGS AS THE XML FILE IS NOT BEING DISPLAYED
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
