Regexp like

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: