Follow me PL/SQL Package to find Factorial and Armstrong Number: /** CREATING PACKAGE **/ create or replace package fact_arm is…
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…
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…
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…
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…
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…
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…
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…
PL/SQL Cursor to Find Total Salary in Department
Follow me PL/SQL Cursor to Find Total Salary in Department: declare dno number; vdno number; totsalary number; cnt number; cursor…
PL/SQL Cursor to Display Names in Uppercase
Follow me PL/SQL Cursor to Display Names in Uppercase: declare cursor upr is select upper(ename)ename from emp order by empno;…