Home » SQL & PL/SQL » SQL & PL/SQL » Triggers (insert, update, delete)
Triggers (insert, update, delete) [message #289638] Mon, 24 December 2007 10:20 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

I have one simple question about pl/sql language for triggers, how to check is record that fired triger is inserting, updating or deleting operation?

for example:
IF <inserting> THEN
DO SOMETHING insert;
IF <updating> THEN
DO SOMETHING update;
IF <deleting> THEN
DO SOMETHING delete;

Thanks in advance! Embarassed

Re: Triggers (insert, update, delete) [message #289639 is a reply to message #289638] Mon, 24 December 2007 10:32 Go to previous messageGo to next message
BlackSwan
Messages: 25045
Registered: January 2009
Location: SoCal
Senior Member
When all else fails, Read The Fine Manual.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_triggers.htm#sthref1143
Re: Triggers (insert, update, delete) [message #289640 is a reply to message #289638] Mon, 24 December 2007 10:35 Go to previous message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Thanks a lot!!! Cool
Previous Topic: insert query problem
Next Topic: HOW to use DBMS_SHARED_POOL package
Goto Forum:
  


Current Time: Wed Dec 07 09:07:06 CST 2016

Total time taken to generate the page: 0.11498 seconds