Skip to Main Content

Application Development 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!

IN cmis query

user1254328Mar 22 2019 — edited Apr 8 2019

Hello,

we have webcenter content and portal 12.2.1.3

SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationName  IN  ( 'Yes' , 'No' )   will fetch us records.

BUT

SELECT * FROM ora:t:IDC:GlobalProfile WHERE ora:p:xRegistrationIdentifierNumber  IN  (  45789 ,  23567 , 33445, 65432 )   -  why this query wont fetch us any records where we are expecting it to fetch 4 records. ?

Comments
Post Details
Added on Mar 22 2019
13 comments
269 views