create or replace trigger stu_ispay_T
before insert on sys_student
for each row
declare
-- local variables here
begin
if :new.stu_area_code='210201' or :new.stu_area_code='210200' or :new.stu_area_code='210202' or :new.stu_area_code='210203' or :new.stu_area_code='210204' or :new.stu_area_code='210211' then
:new.stu_ispay:='0';--ÍâÈýÏØÊÕ·Ñ״̬ĬÈÏΪÒÑÊÕ·Ñ
:new.stu_sub_over:='1';--ÍâÈýÏؽáҵ״̬ĬÈÏΪÒѽáÒµ
end if;
end stu_ispay_T;