adoquery3中的sql语言如下: CREATE TRIGGER aaabeforetrigger before insert on aaa for each row begin select sysdate into :new.edittime from dual; end aaabeforetrigger用户是自己建立的用户admin,权限是RESOURCE,SELECT_CATALOG_ROLE,CONNECT,DBA请各位高手帮我看一看。
是不是已经存在了?sql没问题 CREATE or replace TRIGGER aaabeforetrigger before insert on aaa for each row begin select sysdate into :new.edittime from dual; end aaabeforetrigger;
CREATE OR REPLACE TRIGGER ADMIN.AAABCEFORETRIGGER BEFORE INSERT ON ADMIN.DATA0001 REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW declare abc date; begin select sysdate into abc from dual; end aaabeforetrigger
CREATE TRIGGER aaabeforetrigger
before insert
on aaa for each row
begin
select sysdate into :new.edittime from dual;
end aaabeforetrigger用户是自己建立的用户admin,权限是RESOURCE,SELECT_CATALOG_ROLE,CONNECT,DBA请各位高手帮我看一看。
CREATE or replace TRIGGER aaabeforetrigger
before insert
on aaa for each row
begin
select sysdate into :new.edittime from dual;
end aaabeforetrigger;
BEFORE INSERT
ON ADMIN.DATA0001
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
declare
abc date;
begin
select sysdate into abc from dual;
end aaabeforetrigger