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 Only, Contains Any and Contains Not - how to in PLSQL

user13115886Aug 19 2015 — edited Aug 21 2015

Hi All,

I am trying to write plsql code in which I need some advice.

How can I achieve Contains Only ----- Contains Any ------ Contains Not in PLSQL.

For Ex:

If l_string1 ContainsOnly 'ABCDEFGHIJKL' (A Set of values)

   If l_string2 ContainsAny '+-/'

      If l_string3 ContainsNot '1234567890'

Thanks

Aman
This post has been answered by Frank Kulash on Aug 20 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 18 2015
Added on Aug 19 2015
11 comments
1,875 views