Ilovedatabase’s Blog

Where is the wisdom we have lost in knowledge? Where is the knowledge we have lost in information?

Posts Tagged ‘trigger’

how to create trigger

Posted by ilovedatabase on 24 Feb 2009

**TABLE TRIGGER
We can express a trigger creater code as a general aspect;

CREATE [OR REPLACE] TRIGGER trig_name
{BEFORE|AFTER} {DELETE OR INSERT OR UPDATE}
[OF column_name] ON table_name
[FOR EACH ROW]
DECLARE
--variables
BEGIN
--some code
END;

Brackets represents optionality and “|” means “OR”.

Posted in ORACLE | Tagged: , , , | Leave a Comment »

 
Follow

Get every new post delivered to your Inbox.