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..

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
>statement level triggers..
Work fine & last a long time

Report message to a moderator

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: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
gaytri_25 wrote on Wed, 15 July 2009 12:21
statement level triggers..


...Tuberculosis.

Report message to a moderator

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: 3212
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.

Report message to a moderator

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: 2103
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

Report message to a moderator

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: 1971
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.

Report message to a moderator

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.

Report message to a moderator

Re: triggers [message #414211 is a reply to message #414201] Tue, 21 July 2009 00:40 Go to previous message
Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic: Update error
Next Topic: How to bring the months?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Dec 06 14:53:17 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.