Category: PL/SQL Triggers

In this category of PLSQL Triggers there are various examples of triggers. Every triggers examples will be in very easy logic and in understandable format. You can easily understand it and implement it as your own.

PL/SQL Trigger to Allow User to Make Changes Between 8am to 5pm 0

PL/SQL Trigger to Allow User to Make Changes Between 8am to 5pm

Follow me PL/SQL Trigger to Allow User to Make Changes Between 8am to 5pm: create or replace trigger time2 before update or delete or insert on stud for each row declare hour number; vari...

PL/SQL Trigger to Restrict User to Make Changes After 5pm 0

PL/SQL Trigger to Restrict User to Make Changes After 5pm

Follow me PL/SQL Trigger to Restrict User to Make Changes After 5pm: create or replace trigger time before update or delete or insert on stud for each row declare hour number; vari char(2); begin...

PL/SQL Trigger to Restrict User to Make Changes on Sunday 0

PL/SQL Trigger to Restrict User to Make Changes on Sunday

Follow me PL/SQL Trigger to Restrict User to Make Changes on Sunday : create or replace trigger restrict before update or delete or insert on student for each row declare curr_day varchar(20); begin select...

PL/SQL Trigger to Insert Salary more than 10000 0

PL/SQL Trigger to Insert Salary more than 10000

Follow me PL/SQL Trigger to Insert Salary more than 10000: create or replace trigger vali before insert on emp for each row begin if(:new.salary < 10000)then raise_application_error(-20000,’Salary must be greater than 10000′); end if;...

PL/SQL Trigger to Insert Records in Lowercase 0

PL/SQL Trigger to Insert Records in Lowercase

Follow me PL/SQL Trigger to Insert Records in Lowercase: While Inserting in table the Name Field will always get inserted in Lowercase due to Trigger. create or replace trigger valdata before insert on student...

PL/SQL Trigger to Insert Records in Uppercase 0

PL/SQL Trigger to Insert Records in Uppercase

Follow me PL/SQL Trigger to Insert Records in Uppercase: While Inserting in table the Name Field will always get inserted in Uppercase due to Trigger. create or replace trigger valdata before insert on student...

PL/SQL Trigger to Insert Deleted Record in New Table 0

PL/SQL Trigger to Insert Deleted Record in New Table

Follow me PL/SQL Trigger to Insert Deleted Record in New Table: When any record gets deleted from STUDENT table the that RECORD directly get inserted into ST table. create or replace trigger on_del before...