create or replace trigger trg_IU
before insert or update or delete on table_bill
for each row
declare
v_str varchar2(10);
begin
if inserting then
v_str:='insert';
else
v_str:='update';
end if;
insert into lyx(t_name) values(v_str);
if(to_char(sysdate,'hh24:mi') between '08:00' and '18:00') then
raise_application_error(-20510,'hello a! ');
end if;
end trg_IU;
before insert or update or delete on table_bill
for each row
declare
v_str varchar2(10);
begin
if inserting then
v_str:='insert';
else
v_str:='update';
end if;
insert into lyx(t_name) values(v_str);
if(to_char(sysdate,'hh24:mi') between '08:00' and '18:00') then
raise_application_error(-20510,'hello a! ');
end if;
end trg_IU;