Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

XQuery - In search of alternatives for "ora:view"

Marco GralikeOct 19 2008 — edited Oct 21 2008

Instead of the following XQuery statement, what could be alternatives, regarding re-writing the statement, via options like:
- xmltable
- xsql
- xpath
- table(xmlsequence())
- etc

So I am looking for alternative statements and/or an alternative for ora:view

Thanks for the effort

Marco

xquery
 let $auction := ora:view("XMLType_Table") return
 for $b in $auction/site/people/person[@id = "person0"] return $b/name/text()
/

Edited by: Marco Gralike on Oct 19, 2008 3:48 PM

This post has been answered by Jason_(A_Non) on Oct 21 2008

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 18 2008

Added on Oct 19 2008

#performance-availability, #xml-db

9 comments

4,101 views