oracle数据库密码复杂度查询,Oracle密码复杂度

-----------------------------------脚本如下--------------------------------------------

CREATE OR REPLACE FUNCTION PASSWORD_VERIFY_FUNCTION

(

username varchar2,

password varchar2,

old_password varchar2)

RETURN boolean IS

n boolean;

m integer;

differ integer;

isdigit boolean;

ischar  boolean;

ispunct boolean;

db_name varchar2(40);

digitarray varchar2(20);

punctarray varchar2(25);

specialarray varchar2(14);

chararray varchar2(52);

i_char varchar2(10);

simple_password varchar2(10);

reverse_user varchar2(32);

BEGIN

digitarray:= '0123456789';

chararray:= 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';

specialarray:= '~！@#$%^&*()_<>';

-- 校验密码长度至少为8位

IF length(password