Row level and statement level trigger

Explain Row level and statement level trigger.

A trigger if specified FOR EACH ROW; it is fired for each of the table being affected by the triggering statement. For example if a trigger needs to be fired when rows of a table are deleted, it will be fired as many times the rows are deleted.
If FOR EACH ROW is not specified, it is application to a statement and the trigger is executed at a statement level.

Explain Row level and statement level trigger.

- Row-level: They get fired once for each row in a table affected by the statements.
- Statement-level: They get fired once for each triggering statement.

Explain Row level and statement level trigger.

Row Level Trigger
Row Level Trigger is fired each time row is affected by Insert, Update or Delete command. If statement doesn’t affect any row, no trigger action happens.

Statement Level Trigger
This kind of trigger fires when a SQL statement affects the rows of the table. The trigger activates and performs its activity irrespective of number of rows affected due to SQL statement.

Categories of oracle processes
User process – User process is used in invocation of application software......
What are the Back ground processes in Oracle?
There are a number of background processes running. Each process is used for a specific job....
Guidelines for estimating the space needed for a database
Estimating the space needed for a database is essential to figure out the performance of the application and size of database....
Post your comment