Shulou(Shulou.com)06/01 Report--

Select * from ordtaskremeb_log

Create table ordtaskremeb_log

(

Timeinfo varchar (50)

Oldeqid varchar (20)

Neweqid varchar (20)

Folderno varchar (50)

Ordno varchar (50)

Testno varchar (50)

L_type varchar (20))

CREATE OR REPLACE TRIGGER ordtask_eqid_TRIGGER

AFTER UPDATE of eqid ON ordtask

For each row

DECLARE

V_TYPE ordtaskremeb_log.L_TYPE%TYPE

BEGIN

IF INSERTING THEN

-- INSERT trigger

V_TYPE: = 'INSERT'

ELSIF UPDATING THEN

-- UPDATE trigger

V_TYPE: = 'UPDATE'

END IF

INSERT INTO ordtaskremeb_log (timeinfo,oldeqid,neweqid,folderno,ordno,testno,l_type)

VALUES

(TO_CHAR (SYSDATE, 'yyyy-mm-dd hh34:mi:ss'),: old.eqid,:new.eqid,:old.folderno,:old.ordno,:old.testno,V_TYPE);-- USER represents the current user name

END ordtask_eqid_TRIGGER

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.