Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
create or replace FUNCTION Month_Open(yr number,mn number) RETURN INTEGER IS lDummy INTEGER; BEGIN SELECT count(*) INTO lDummy FROM serial where year=yr AND month = mn; RETURN lDummy; EXCEPTION WHEN NO_DATA_FOUND THEN RETURN 0; END month_open;
create or replace TRIGGER LUCK_ser_month_close after UPDATE of close_flag ON month_close for each row BEGIN if month_open(:old.year,:old.month-1) then if :new.close_flag = 1 then raise_application_error (-20500,'You Cannot '); end if; end if; END;