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!

regluar expression: at least one number AND at least one capital letter.

WestDraytonMar 12 2010 — edited Mar 12 2010
How to write regular expression to determine rule:

1) input string must contain at least one number. For example '0A1' contains 2 numberic symbols, but 'Abc' doesn't contain. At least one numeric symbol must occur.
2) input string must also contain one capital letter. for example '0A1' contains capital A, but '0a1' doesn't. At least one capital letter must exist in

Bot 1) and 2) must be true for input string.

How to write such regular expression?
This post has been answered by MichaelS on Mar 12 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2010
Added on Mar 12 2010
16 comments
3,302 views