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? 
Hotmail: Powerful Free email with security by Microsoft.

Other related posts: