hai i have created an xmlschema and registered it.
and created a table of xmltype with xmlschema.
The xml follows like this
Time to Think
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