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

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 21 2007

Added on Feb 21 2007

4 comments

772 views