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!

contains/like in pl/sql variable of type clob

managed BEANMar 28 2017 — edited Mar 29 2017

Hello everyone,

I have a clob variable in a pl/sql procedure where it is assigned a value.

I would like to know if the clob contains a 'substring' without the select statement, something alike to : clob.contains("%myText%") as in JAVA.

Is it possible? If so, how?

Thanks in advance.

Regards,

Carlos
This post has been answered by John Thorton on Mar 28 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 26 2017
Added on Mar 28 2017
#variable
12 comments
2,605 views