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 can I extract a string after a specific word ?

francislazaroMar 21 2017 — edited Mar 21 2017

I have a clob text  column with more than 500 words in it. I want to extract the word right after that specific word. The position of the original string can vary in the CLOB text

For example:

HEALTH IS VERY IMPORTANT 780037867267

A BOY EATS AN APPLE

GAINS

ENERGY

I want to extract the word right after apple which is GAINS.

How can I write a query to extract the word GAINS ? The position of the word apple is not constant in the dataset.
This post has been answered by Frank Kulash on Mar 21 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2017
Added on Mar 21 2017
11 comments
3,096 views