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!

Finding exact match in a string with REGEXP

cmovvaDec 9 2011 — edited Dec 9 2011
Hi all,
How can I find an exact match(just alpha characters only) in a string? I need to check for a particular key word(e.g. NAME either all lower case or all uppercase oare ok) in a string and if exists return true else false. DB is 10g.

Thanks in advance
movva
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2012
Added on Dec 9 2011
4 comments
4,436 views