priya

A WHEN clause specifies the condition that must be true for the trigger to be triggered. In PL/SQL triggers, the WHEN clause is used to specify a condition under which the trigger should be fired. The WHEN clause allows you to define a condition that, when true, activates the trigger and executes its associated trigger … Read more

When a trigger is associated to a view, the base table triggers are normally enabled. In PL/SQL, a trigger cannot be directly associated with a view. Triggers are typically associated with tables and are used to automatically execute a set of PL/SQL statements in response to specific events on the table, such as INSERT, UPDATE, … Read more

A trigger is automatically executed without any action required by the user, while, a stored procedure is explicitly invoked by the user. In PL/SQL, triggers and stored procedures serve different purposes, and there are several key differences between their execution: Trigger Execution: Triggers are automatically executed or fired in response to specific events on a … Read more

There are 12 types of triggers in PL/SQL that contains the combination of BEFORE, AFTER, ROW, TABLE, INSERT, UPDATE, DELETE and ALL keywords. BEFORE ALL ROW INSERT AFTER ALL ROW INSERT BEFORE INSERT AFTER INSERT etc. In PL/SQL, there are two main types of triggers: Row-level triggers: These triggers are fired once for each row … Read more

12 triggers. In PL/SQL, there is no predefined maximum limit on the number of triggers you can apply to a single table. However, keep in mind that each trigger you define for a table adds to the overall complexity of the database and can impact performance. While there is no strict limit on the number … Read more