利用translate函数判断字符串是否包含数字和字母
定义:
translate(str,from_str, to_str)
translate('abc123', '132','de')=abcde
1替换为d,3替换为e,2替换为空
例如:
select * FROM
csdn_db
where
email like '%@163.com'
and length(password) > 5
and length(password) != length(translate(password,'a0123456789','a'))
and length(password) != length(translate(password,'0abcdefghijklmnopqrstuvwxyz','0'))
and rownum < 1000