Skip to Main Content
Forums

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 check multiple special characters in instr function sql query.

600424Sep 28 2007 — edited Sep 28 2007
Hi,

The following special characters are comma(,), slash(/), colan(:)

these special characters i need to be check in instr function.

select SUBSTR(master_title,1,INSTR(master_title,',',1,1)-1) from dual;


Can you please write the query with right answer.

Thanks in advance,
Lakshman.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2007
Added on Sep 28 2007
1 comment
583 views