create or replace trigger TEST1_INSERT after Insert on TEST1 for each Row
Declare
PRAGMA AUTONOMOUS_TRANSACTION;
Begin
Update TEST1 Set YEARVALUE=SUBSTR(DATEVALUE,1,4),MONTHVALUE=SUBSTR(DATEVALUE,6,2)
Where DATEVALUE=:new.datevalue;
Commit;
end TEST1;插入一行数据,且更新此行数据列(从datevalue中取,年,月) yearvalue ,monthvalue 请教???万分火急!!!
Declare
PRAGMA AUTONOMOUS_TRANSACTION;
Begin
Update TEST1 Set YEARVALUE=SUBSTR(DATEVALUE,1,4),MONTHVALUE=SUBSTR(DATEVALUE,6,2)
Where DATEVALUE=:new.datevalue;
Commit;
end TEST1;插入一行数据,且更新此行数据列(从datevalue中取,年,月) yearvalue ,monthvalue 请教???万分火急!!!
Declare
Begin
:new.YEARVALUE:=SUBSTR(:new.DATEVALUE,1,4);
:new.MONTHVALUE:=SUBSTR(:new.DATEVALUE,6,2)
end TEST1;
Declare
Begin
:new.YEARVALUE:=SUBSTR(:new.DATEVALUE,1,4);
:new.MONTHVALUE:=SUBSTR(:new.DATEVALUE,6,2)
end TEST1;
create or replace trigger TEST1_INSERT after Insert on TEST1 for each Row
Begin
:new.YEARVALUE=SUBSTR(:new.DATEVALUE,1,4);
:new.MONTHVALUE=SUBSTR(:new.DATEVALUE,6,2)
end TEST1;