sona
10-08-2002, 01:33 AM
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">"Master Mind"<"/Title">"
"<"Author">"Subhash"<"/Author">"
"<"Title">"Discovery of India"<"/Title">"
"<"Author">"Nehru"<"/Author">"
"<"/Book">"
;
;
;
"<"/BookStore">"
Please ignore the quotation marks everywhere
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.
[Edited by sona on 10-08-2002 at 01:38 AM]
(ORacle 9i)
and created a table of xmltype with xmlschema.
The xml follows like this
"<"BookStore">"
"<"Book">"
"<"Title">"Master Mind"<"/Title">"
"<"Author">"Subhash"<"/Author">"
"<"Title">"Discovery of India"<"/Title">"
"<"Author">"Nehru"<"/Author">"
"<"/Book">"
;
;
;
"<"/BookStore">"
Please ignore the quotation marks everywhere
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.
[Edited by sona on 10-08-2002 at 01:38 AM]