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!

Selecting rows where column string contains particular character.

504701Jun 3 2009 — edited Jun 3 2009
Hey There,

Im trying to select rows based on a column containing a forward slash.

I have tried

where substr(col1, INSTR(col1,'/'), INSTR(col1,'/')+1)

but no luck, is there a particular way of handling this?

Thanks in advance,
Dob
This post has been answered by 21205 on Jun 3 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2009
Added on Jun 3 2009
6 comments
5,363 views