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 select a string between nth specific character to nth+1 character

900707Aug 9 2012 — edited Aug 9 2012
Hi,

I have one string 'SWAP_20120224_MEGAMART_MAR_Sales.csv'

I want to get the string between second underscore and third underscore i.e. 'MEGAMART'
How to achieve this in sql statement.

Thanks for the help.

Regards
This post has been answered by Frank Kulash on Aug 9 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 6 2012
Added on Aug 9 2012
4 comments
5,254 views