OraFAQ Forum: Server Administration » what is difference between rowlevel trigger and statement level trigger

Home » RDBMS Server » Server Administration » what is difference between rowlevel trigger and statement level trigger

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is difference between rowlevel trigger and statement level trigger [message #212439]

Fri, 05 January 2007 05:23

rajita
Messages: 2
Registered: January 2007
Location: mumbai

Junior Member

No Message Body

Report message to a moderator

Re: what is difference between rowlevel trigger and statement level trigger [message #212440 is a reply to message #212439]

Fri, 05 January 2007 05:27

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Check the docs (Triggers).

Report message to a moderator

Re: what is difference between rowlevel trigger and statement level trigger [message #212986 is a reply to message #212439]

Tue, 09 January 2007 01:07

jaydeep.desai
Messages: 4
Registered: January 2007
Location: Mumbai

Junior Member

Row level trigger fires for each affected row n statement level trigger fires once for all affected rows by the statement

U can get this all basic from PLSQL book only Razz

Report message to a moderator

Re: what is difference between rowlevel trigger and statement level trigger [message #212990 is a reply to message #212986]

Tue, 09 January 2007 01:12

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

One more good place to find the answers is here

Report message to a moderator

Previous Topic:	Error in identifying Controlfile
Next Topic:	ORA-01002 Fetch Out of Sequence Error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:32:03 CDT 2024