PLSQL: TRIGGERES - BEFORE, AFTER, ROW LEVEL, STATEMENT LEVEL, CONDITIONAL TRIGGERS

Write a trigger to display a message whenever a record is inserted into EMP table.

(Trigger Basics)

Write a trigger that fires before inserting data into EMP table.

(BEFORE INSERT Trigger)

Write a trigger that fires after deleting a record from EMP table.

(AFTER DELETE Trigger)

Write a trigger to prevent deletion from EMP table.

(BEFORE DELETE Trigger)

Write a trigger to display a message when employee salary is updated.

(AFTER UPDATE Trigger)

Write a row-level trigger to display old and new salary when salary is updated.

(:OLD and :NEW)

Write a trigger to restrict salary update if new salary is less than old salary.

(Row-Level Trigger + Validation)

Write a trigger to automatically set hiredate while inserting employee record.

(BEFORE INSERT + :NEW)

Write a trigger to increase salary by 5% before updating.

(BEFORE UPDATE Trigger)

Write a trigger to copy deleted records into another table (audit table).

(AFTER DELETE + Logging)

Write a statement-level trigger to display message when any insert occurs on EMP table.

(Statement-Level Trigger)

Write a statement-level trigger to log update operations on EMP table.

(Logging Trigger)

Write a trigger that fires once for DELETE statement regardless of number of rows.

(Statement-Level Trigger)

Write a BEFORE trigger to validate salary before inserting.

(BEFORE Trigger)

Write an AFTER trigger to log inserted employee records.

(AFTER Trigger)

Write both BEFORE and AFTER triggers for UPDATE operation.

(Comparison)

Write a trigger that fires only when salary > 5000.

(Conditional Trigger)

Write a trigger to allow insert only during working hours.

Write a trigger to prevent update on weekends.

(Conditional Logic)

Write a trigger to maintain audit table for INSERT, UPDATE, DELETE.

(Audit Trigger)

Write a trigger to generate automatic employee ID.

(Auto Increment Logic)

Write a trigger to enforce referential integrity manually.

(Integrity Check)

Write a trigger to calculate bonus after salary update.

Write a trigger to track number of rows affected.

(Advanced Logic)

Write a trigger to prevent duplicate employee names.

(Validation Trigger)

Write a trigger to log user activity (who updated, when updated).

(Audit + USER, SYSDATE)

Write a trigger to restrict salary update beyond 20%.

Write a trigger that calls a procedure from a package.

(Trigger + Package Integration)

Write a trigger to maintain history table for salary changes.

Write a compound trigger (advanced Oracle feature).

(Compound Trigger)