This discussion is archived
4 Replies Latest reply: Dec 6, 2012 4:45 AM by RajeshKanna RSS

Read the xmldata from table

RajeshKanna Newbie
Currently Being Moderated

I have created the following table contains only one column

create table book_inf (booksinf clob);

the booksinf column contains the following xmldata
  <BOOK-ID> I1001 </BOOK-ID>
how to read the values book-id and book-name one by one by using DBMS_LOB.

can any one help me..?


  • Correct Answers - 10 points
  • Helpful Answers - 5 points