Skip to Main Content

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!

Hi, How to select Nth word from sentence/String in Pl/SQL

016ccb58-9cae-4bb8-b009-2303ca5efe89Nov 18 2014 — edited Nov 18 2014

Hi ,

I want to select Nth word from sentence / String in Pl/Sql

String := KLPALEWAR@GMAIL.COM 10600513 09011952

I want to select 2nd word ie :  10600513

Please help Thanks in advance .

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2014
Added on Nov 18 2014
4 comments
6,667 views