Trigger-SQL Server Example and Oracle Sample

[ragav...@gmail.com]

Trigger:
********
What is Trigger?
Trigger is nothing but Stored Procedure. but it can be executed
automatically when insert, update and delete the table in database.

+++++++++++++++
SQL Server Example:
+++++++++++++++

CREATE TRIGGER TRAU_PRODUCT ON PRODUCT
FOR UPDATE
AS
IF UPDATE (PROD_PRICE_N)
INSERT INTO acme.dbo.PRODUCT_AUDIT
SELECT i.PROD_ID_N,
d.PROD_PRICE_N,
i.PROD_PRICE_N,
USER,
GETDATE()
FROM INSERTED i
JOIN
DELETED d
ON i.PROD_ID_N = d.PROD_ID_N
GO

+++++++++++++++++++++++
+++++++++++++++++++++++
Oracle Trigger:
+++++++++++++++++++++++
+++++++++++++++++++++++
--
-- TRIGGER TRAU_PRODUCT
--

CREATE OR REPLACE TRIGGER TRAU_PRODUCT
BEFORE UPDATE OF PROD_PRICE_N ON PRODUCT
FOR EACH ROW
Begin
INSERT INTO PRODUCT_AUDIT
VALUES (:NEW.PROD_ID_N,
:OLD.PROD_PRICE_N,
:NEW.PROD_PRICE_N,
USER,
SYSDATE);
END;

Regards,
Ragavan

/