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!

problem with substr

user11289444Feb 5 2010 — edited Apr 16 2010
hi
i have the following string

'ram2/11king'
'Pinnnn3/12queen'

I want to retrive the contents before slash and after slash seperately..

select substr('ram2/11king',instr('ram2/11king','/',1)+1) from dual

I want to retrive ram2 seperately and 11king seperately

I am able to do retrive 11king from the above select


how can i retrive ram2 and pinnn3 string before slash


Thanks,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2010
Added on Feb 5 2010
8 comments
1,203 views