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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

regexp_like

PGRWSep 22 2007 — edited Nov 4 2010
This function seems like a good idea for password validation, for example one number and 4-8 characters.

However, this does not work - any ideas?

select
1 from dual where
regexp_like(upper('PA55WORD'),'^(?=.*\d).{4,8}$')

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 21 2007
Added on Sep 22 2007
10 comments
5,684 views