DML Trigger - To raise error when user enter salary less than 2000 - PLSQL Oracle (Trigger Demo-1)

Опубликовано: 12 Февраль 2025
на канале: Dr. Parag Shukla
1,681
22

This video practically demonstrates how to write PLSQL DML Trigger in Oracle with update of salary of employee.

It also shows how to enable and disable the triggers.

WRITE DML TRIGGER ON EMP TABLE THAT WHENEVER USER UPDATE OR INSERT THE SALARY OF EMPLOYEE LESS THAN 2000 THEN RAISE THE ERROR 'MINIMUM SALARY MUST BE 2000'

ALSO SHOWS INSERT AND UPDATE AFTER DISABLING THE TRIGGER.


For Learning More about Programming
Subscribe to My Channel: https://www.youtube.com/c/drparagshuk...