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: 26766
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: Mon Feb 17 22:18:04 CST 2025