xmldb Question

[sona]

hai i have created an xmlschema and registered it.
(ORacle 9i)
and created a table of xmltype with xmlschema.

The xml follows like this

<BookStore>
<Book>
<title> MasterMind </title>
<Author> Adam </Author>
</Book>
<Book>
<title> Time to Think </title>
<Author> John </Author>
</Book>
..

</BookStore>

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.

[stecal]

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:

It's hard to get around using the brackets.


[Edited by stecal on 10-04-2002 at 06:31 PM]