Home » SQL & PL/SQL » SQL & PL/SQL » triggers (oracle9i, Windows XP..SP2)
triggers [message #413417] Wed, 15 July 2009 11:21 Go to next message
gaytri_25
Messages: 6
Registered: July 2009
Location: mumbai
Junior Member

statement level triggers..
Re: triggers [message #413419 is a reply to message #413417] Wed, 15 July 2009 11:23 Go to previous messageGo to next message
BlackSwan
Messages: 25034
Registered: January 2009
Location: SoCal
Senior Member
>statement level triggers..
Work fine & last a long time
Re: triggers [message #413439 is a reply to message #413417] Wed, 15 July 2009 12:47 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
gaytri_25 wrote on Wed, 15 July 2009 12:21
statement level triggers..


...Tuberculosis.

Re: triggers [message #413441 is a reply to message #413417] Wed, 15 July 2009 12:57 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
gaytri_25 wrote on Wed, 15 July 2009 18:21
statement level triggers..


.. can be the source of much joy. Or much pain. Depending on who wrote them where and why.
Re: triggers [message #413878 is a reply to message #413441] Sat, 18 July 2009 00:17 Go to previous messageGo to next message
Kevin Meade
Messages: 2101
Registered: December 1999
Location: Connecticut USA
Senior Member
ah... finally, someone with true wisdom speaks.

too many with little knowledge are so eager to rebuke the use of triggers. But I like the way you say it:

Quote:
{triggers} .. can be the source of much joy. Or much pain. Depending on who wrote them where and why.


How true. I find triggers so joyful when used as a cohesive design strategy by an experienced application DBA who hides behaviour in the database so that applications do not see it, and oh so painful when triggers are wielded by developers in a hurry who are looking for a quick fix that seems to get them what they want but who have little care for what the future will bring because of their misuse of this database feature.

One of these days I think I'll publish a work on the joys of instead of triggers.

Again, thanks for this comment. Kevin
Re: triggers [message #414181 is a reply to message #413417] Mon, 20 July 2009 14:09 Go to previous messageGo to next message
Bill B
Messages: 1482
Registered: December 2004
Senior Member
statement level triggers run once per DML statement. row level triggers work on every row affected by the DML statement.
Re: triggers [message #414201 is a reply to message #413417] Mon, 20 July 2009 23:15 Go to previous messageGo to next message
ds285269
Messages: 10
Registered: June 2009
Location: Mumbai
Junior Member
Hi gayati,
Statement level trigger fired only once for our DML,
But row level trigger are fired on every row effeted on DMl statement.
Re: triggers [message #414211 is a reply to message #414201] Tue, 21 July 2009 00:40 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
@ds285269, if my copy machine ever fails, I'll contact you. Though, perhaps you should clean your optical device (as it seems that OCR doesn't work perfectly).
Previous Topic: Update error
Next Topic: How to bring the months?
Goto Forum:
  


Current Time: Sat Dec 03 14:03:51 CST 2016

Total time taken to generate the page: 0.22833 seconds