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
Hi,

I have created the following table contains only one column

create table book_inf (booksinf clob);

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

can any one help me..?

Legend

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