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!

How can I test if a string only contains invalid characters

user479119Feb 21 2007 — edited Feb 21 2007
Hi

I need to create a function to test if a string does not contain any valid characters

e.g. '########' or '********' etc.

If the string contains at least one character that is numeric or letters 'A' - 'Z' then I want to return the string. Otherwise I plan to filter it out.

Can anyone please suggest the best way to test for this?

Thanks
GB
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 21 2007
Added on Feb 21 2007
4 comments
772 views