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!

Extract everything starting from specific text in the CLOB field ?

francislazaroMar 24 2017 — edited Mar 24 2017

How can I extract everything that begins with a certain word ?

My column data looks like below. I want to extract everything starting from the word 'Final' till the end of the text.

Russia has a target of 10,000 lbs while all the other countries have a target of 20,000 lbs

Final Notes for this text

A  BCHjksykeuuiejeeeu

ehjhrel;lroiyu32yyuiuiu43

This post has been answered by BluShadow on Mar 24 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2017
Added on Mar 24 2017
12 comments
2,945 views