Regexp like
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 4 Feb 2010 11:23:33 -0600
Has anybody used REGEXP_LIKE to validate passwords?
I have a table with strings (i.e. passwords) but this select is not returning
any values.
select * from dept
where REGEXP_LIKE(LOC,'^.*(?=.*{9,})(?=.*\d)(?=.*[A-Za-z])(?=.*[_#]).*$'));
this should return strings with
at least 9 char
at least 1 digit
at least _ # special char
at least a lower or upper case char
Does any have any experience with this?
thanks,
_________________________________________________________________
Hotmail: Powerful Free email with security by Microsoft.
http://clk.atdmt.com/GBL/go/201469230/direct/01/
Other related posts:
