Regexp like

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 4 Feb 2010 11:23:33 -0600
Message-ID: <BLU108-W204ABCEE0BFA0473ABA92D97550_at_phx.gbl>

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/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 04 2010 - 11:23:33 CST