Skip to Main Content

Integration

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!

How to create SQL IN filter using XQuery FLWOR

868034Nov 8 2011 — edited Nov 9 2011
Is it possible to create such FLWOR expression that will be pushed down to SQL using "SQL IN" filtering?

Assuming following function declaration:

declare function tns:filterOnLevels($levels as xs:double+) { ...

I'd like to create FLWOR expression that will be pushed down to such SQL:
select * from LEVELS where level IN ($levels)

And executing tns:filterOnLevels(1,2,3) should execute statement with "where level IN (1,2,3)". SQL IN-like filtering have to be pushed down to SQL because executing unconstrained query could result with too many records.

Is such expression possible to do in XQuery/XQSE or maybe other fn-bea extensions?

I'm working on ODSI/Workshop 10.3 and Oracle 10g.
This post has been answered by Mike Reiche-Oracle on Nov 8 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2011
Added on Nov 8 2011
2 comments
1,668 views