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.