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!

how to tell a list of numbers separated by ';' contains a particular number

Jian-cdoNov 30 2022

Hello,
Assume column study_ID has value like '25:28:29', or '27:28:29' , then I need to get the row value with column A has value of 25. I tried to use Contains, such as "where otherConditions and contains(TBL_MASTER_CONTACT.study_ID,'25',1)>0 ", then it complains about "-10599: column is not indexed" even after I created index on the column. Any clue here? Thanks.

This post has been answered by Frank Kulash on Nov 30 2022

Jump to Answer

Added on Nov 30 2022

#sql

3 comments

90 views

1 mention