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!

SELECT part of a string

826241Mar 3 2011 — edited Mar 3 2011

DB version:10gR2

create table mydummy (test_str varchar2(45));

insert into mydummy values ('Hello+there');
insert into mydummy values ('Dummy+footprint');

I want the query to return the part of string which is after the plus sign

Result should look like

there
footprint

I know that SUBSTR function has to be used. But i don't know how to eliminate everything till the plus sign

This post has been answered by Saubhik on Mar 3 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 31 2011

Added on Mar 3 2011

5 comments

4,989 views