Insert or Update or Delete: This specifies the DML operation. One or more triggering event can be used together if needed.The trigger gets fired at all the specified triggering event.END IF; IF UPDATING THEN /* write the code that u want to work for UPDATE statement. If you want to use IM speak, use MSN messenger or the like. If you start calling names, don't bother coming back. The original post on that point was made with a degree of sarcasm and was clearly meant as a minor dig and bit of a joke.END IF; IF DELETING THEN /* write the code that u want to work for DELETE statement. If you want to start a serious conversation with Oracle professionals, use professional language not . The offender then took far too aggressive a standpoint using abusive language which In My Opinion warranted the slating that he/she got.END IF; END ; INSERTING/UPDATING/DELETING are ORACLE keywords. Several people contributed to your original post in amongst the other discussion, yet you have not deigned to address any of the points brought up. Using rubbish like U, plz, thx and gr8, should be confined to (as Maaher says) AIM or Messenger. I suppose you save another three by abbreviating "dumbass" to "dumb", though if you had written "what U means in the internet language" instead of "what does U mean in the internet language" you would have saved another four. and plez Concentrate on helping junior programmers rather then fighting eachother on language/communication skills.
for that i want to write trigger on table after insert,update and delete .. INV_CONTACT 7 ( 8 COM_CD, 9 cont_cd, 10 CONT_NM, 11 CONT_ADD, 12 CONT_STR, 13 cont_type, 14 xxcont_cd 15 ) 16 values 17 ( 18 '1', 19 max_contact, 20 :new.vendor_nm, 21 :new.vendor_add1, 22 :new.vendor_str, 23 'PARTY', 24 :new.vendor_Cd 25 ); 26 end; Hi annu-agi. Oracle utilises enough abbreviations of it's own, in addition, Orafaq is a truly international site with posters from every corner of the globe, some with excellent English skills, some with slighter weaker skills.A trigger therefore helps to prevent invalid transactions, duplication of tables/data, forced referential integrity and provides security authorizations.The parts of a PL/SQL trigger are SQL statements of a trigger, trigger action statement and trigger restrictions.Statement level trigger: Here, the event is executed foreach SQL statement or a complete table.Here, we have created a trigger which ensures that we don’t enter any Admin who has a salary less than 1000.Wenn Sie sich zur Teilnahme entscheiden, wird Ihnen die Onlineumfrage angezeigt, sobald Sie die Msdn Website verlassen. PL/SQL triggers are block structures or pre-defined programs, which may be in-built or even explicitly developed by the programmers for a particular task.CREATE OR REPLACE TRIGGER AUDT_TSTTRIG BEFORE INSERT OR UPDATE OR DELETE ON TSTTRIG FOR EACH ROW DECLARE TIP VARCHAR2(10); BEGIN IF INSERTING THEN TIP := 'INSERT'; ELSIF UPDATING THEN TIP := 'UPDATE'; ELSIF DELETING THEN TIP := 'DELETE'; END IF; INSERT INTO MYAUDIT(MYAUDIT. NM); END AUDT_TSTTRIG; / CREATE OR REPLACE TRIGGER AUDT_TSTTRIG 2 BEFORE INSERT OR UPDATE OR DELETE ON TSTTRIG 3 FOR EACH ROW 4 5 DECLARE 6 7 TIP VARCHAR2(10); 8 9 BEGIN 10 11 IF INSERTING THEN 12 TIP := 'INSERT'; 13 ELSIF UPDATING THEN 14 TIP := 'UPDATE'; 15 ELSIF DELETING THEN 16 TIP := 'DELETE'; 17 END IF; 18 19 INSERT INTO MYAUDIT(MYAUDIT. SELECT * FROM MYAUDIT 2 / POLZ VIZM OPER NZAP HIST -------- ----------- -------- -------- ----------------------------------------- MILLER INSERT NULL Old Name: "NULL" New Name: ALFRED MILLER UPDATE 8001 Old Name: ALFRED New Name: ALF SELECT * FROM MYAUDIT 2 / POLZ VIZM OPER NZAP HIST -------- ----------- -------- -------- ----------------------------------------- MILLER INSERT NULL Old Name: "NULL" New Name: ALFRED MILLER UPDATE 8001 Old Name: ALFRED New Name: ALF MILLER DELETE NULL Old Name: ALF New Name: "NULL" CREATE OR REPLACE TRIGGER AFT_AUDT_TSTTRIG AFTER INSERT OR UPDATE OR DELETE ON TSTTRIG FOR EACH ROW DECLARE TIP VARCHAR2(10); BEGIN IF INSERTING THEN TIP := 'INSERT'; ELSIF UPDATING THEN TIP := 'UPDATE'; ELSIF DELETING THEN TIP := 'DELETE'; END IF; INSERT INTO MYAUDIT(MYAUDIT. hello experts, I have two table with similer like structure in two diffrent users. here i m submitting the code and errors defination :- user 1 --- FINANCIAL user 2 --- INVENTORY user 1 table : vendor user 2 table : inv_contact --- this trigger is create on financial. where the max_contact is function written in INVENTORY for max serial no generation and it is not null PK. not via a role) (not so)Quick point, The discussion that went before was not fighting.