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

    Read the xmldata from table


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