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 .

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 16 2014

Added on Nov 18 2014

4 comments

6,667 views