Home » RDBMS Server » Server Administration » what is difference between rowlevel trigger and statement level trigger
what is difference between rowlevel trigger and statement level trigger [message #212439] Fri, 05 January 2007 05:23 Go to next message
rajita
Messages: 2
Registered: January 2007
Location: mumbai
Junior Member
No Message Body
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 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check the docs (Triggers).
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 Go to previous messageGo to next message
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
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 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

One more good place to find the answers is here
Previous Topic: Error in identifying Controlfile
Next Topic: ORA-01002 Fetch Out of Sequence Error
Goto Forum:
  


Current Time: Sat Dec 03 07:52:09 CST 2016

Total time taken to generate the page: 0.09323 seconds