Home » SQL & PL/SQL » SQL & PL/SQL » Diff betweeen before insert and after insert in trigger?
Diff betweeen before insert and after insert in trigger? [message #230579] Thu, 12 April 2007 04:22 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

Diff betweeen before insert and after insert in trigger?

please explain details..


Arun..
Re: Diff betweeen before insert and after insert in trigger? [message #230581 is a reply to message #230579] Thu, 12 April 2007 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64131
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Before insert" is executed before insert core statement.
"After insert" is executed after insert core statement.
For instance, you can't modify values in after insert trigger as insert already happened.

Regards
Michel

Re: Diff betweeen before insert and after insert in trigger? [message #230602 is a reply to message #230581] Thu, 12 April 2007 05:02 Go to previous messageGo to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

pls examples of both of them..

Arun
Re: Diff betweeen before insert and after insert in trigger? [message #230603 is a reply to message #230602] Thu, 12 April 2007 05:06 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
akkumar81 wrote on Thu, 12 April 2007 12:02
pls examples of both of them..

Arun

Oracle has MANUALS! Check them out. A link can be found in the sticky ("tips and tricks").


I urge others to do the same: bookmark those manuals, learn from them!

MHE
Re: Diff betweeen before insert and after insert in trigger? [message #230642 is a reply to message #230602] Thu, 12 April 2007 07:55 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
akkumar81 wrote on Thu, 12 April 2007 06:02
pls examples of both of them..

Arun


How do you expect to get anywhere in life with such a lazy attitude as such? Jeez!
Previous Topic: Difference between two rows
Next Topic: Trigger problem
Goto Forum:
  


Current Time: Wed Dec 07 14:13:11 CST 2016

Total time taken to generate the page: 0.12169 seconds