Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.
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;
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.