DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: How to read XML Data stored as Clob

  1. #1
    Join Date
    Feb 2001
    Posts
    119

    How to read XML Data stored as Clob

    An XML data has been dumped into a Clob field in a Oracle Table.

    SQL> desc XML_TEST1
    Name Null? Type
    ----------------------------------------- -------- -------
    XMLTEST CLOB
    How do we read the data in sqlplus.

    Any examples will be of much help.
    I am a XML newbee.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    read it into what?

  3. #3
    Join Date
    Feb 2001
    Posts
    119
    Read like any other tables.
    I want to populate the data into a normal table.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    How do you want to populate the other table.
    If the first table stores the xml in clob do you want to shred the xml into relational when you store it into table B ?

    regards
    Hrishy

  5. #5
    Join Date
    Feb 2001
    Posts
    119
    Yes.I want to read the clob and move the data to another table.

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    When you the data to another table in another table will it be stored in relational format or in clob ?

    post a small example here.

    regards
    Hrishy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width