xmldb Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: xmldb Question

  1. #1
    Join Date
    Apr 2002
    Posts
    135
    hai i have created an xmlschema and registered it.
    (ORacle 9i)
    and created a table of xmltype with xmlschema.

    The xml follows like this



    MasterMind
    Adam


    Time to Think
    John

    ..



    I want to write a query to perform the following,

    Like i want to get the author name for the specific Title given.
    I tried using extractvalue in where condition but i got error :"single row returns multiple values" something like that.

    The above is a single xml row.

    IS there any way.

    Good Judgement comes from Experience.
    Experience comes from Bad Judgement

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    For your post, you need to add "["code"]" before your XML code and "["/code"]" at the end so your tags will appear in the forum. Ignore the " marks above - they're in so the board won't try and format what I wrote like this:
    Code:
    It's hard to get around using the brackets.
    [Edited by stecal on 10-04-2002 at 06:31 PM]

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