PL/SQL Package to find Factorial and Armstrong Number: /** CREATING PACKAGE **/ create or replace package fact_arm is function factorial(n…
add commentPL/SQL Trigger to Allow User to Make Changes Between 8am to 5pm: create or replace trigger time2 before update or…
add commentPL/SQL Trigger to Restrict User to Make Changes After 5pm: create or replace trigger time before update or delete or…
add commentPL/SQL Trigger to Restrict User to Make Changes on Sunday : create or replace trigger restrict before update or delete…
add commentPL/SQL Trigger to Insert Salary more than 10000: create or replace trigger vali before insert on emp for each row…
add commentPL/SQL Trigger to Insert Records in Lowercase: While Inserting in table the Name Field will always get inserted in Lowercase…
add commentPL/SQL Trigger to Insert Records in Uppercase: While Inserting in table the Name Field will always get inserted in Uppercase…
add commentPL/SQL Trigger to Insert Deleted Record in New Table: When any record gets deleted from STUDENT table the that RECORD…
add commentPL/SQL Cursor to Find Total Salary in Department: declare dno number; vdno number; totsalary number; cnt number; cursor tot_sal(vdno number)…
add commentPL/SQL Cursor to Display Names in Uppercase: declare cursor upr is select upper(ename)ename from emp order by empno; begin for…
add comment