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