Skip to Main Content

SQL & PL/SQL

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!

SQL Query using CONTAINS

User_FA17FJun 24 2021

Can someone explain how the CONTAINS function works, we are searching a CLOB that contains the text NON-XXX but when we give the following query
SELECT test FROM test_table where CONTAINS(text, '{NON-XXX}')> 0 we do not get any hits.
The table test_table hold a record that has the text NON-XXX.
The column text is of type CLOB.
Thanks

Comments
Post Details
Added on Jun 24 2021
1 comment
259 views