--增加一个约束不就行了 alter table usertable add check(length(psd) between 6 and 12)
CREATE OR REPLACE TRIGGER tri_usertable AFTER INSERT ON usertable FOR EACH ROW DECLARE psd_length number; BEGIN psd_length:=:NEW.PSD; IF length(psd_length)>12 or length(psd_length)<6 THEN ROLLBACK; END IF; END;
--增加一个约束不就行了
alter table usertable add check(length(psd) between 6 and 12)
AFTER INSERT
ON usertable
FOR EACH ROW
DECLARE
psd_length number;
BEGIN
psd_length:=:NEW.PSD;
IF length(psd_length)>12 or length(psd_length)<6 THEN
ROLLBACK;
END IF;
END;