4 Replies Latest reply on Dec 6, 2012 12:49 PM by BluShadow

    Read the xmldata from table

    RajeshKanna
      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..?