PL/SQL Package to find Factorial and Armstrong Number

PL/SQL Package to find Factorial and Armstrong Number: /** CREATING PACKAGE **/ create or replace package fact_arm is function factorial(n…

add comment

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

PL/SQL Trigger to Allow User to Make Changes Between 8am to 5pm: create or replace trigger time2 before update or…

add comment

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

PL/SQL Trigger to Restrict User to Make Changes After 5pm: create or replace trigger time before update or delete or…

add comment

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

PL/SQL Trigger to Restrict User to Make Changes on Sunday : create or replace trigger restrict before update or delete…

add comment

PL/SQL Trigger to Insert Salary more than 10000

PL/SQL Trigger to Insert Salary more than 10000: create or replace trigger vali before insert on emp for each row…

add comment

PL/SQL Trigger to Insert Records in Lowercase

PL/SQL Trigger to Insert Records in Lowercase: While Inserting in table the Name Field will always get inserted in Lowercase…

add comment

PL/SQL Trigger to Insert Records in Uppercase

PL/SQL Trigger to Insert Records in Uppercase: While Inserting in table the Name Field will always get inserted in Uppercase…

add comment

PL/SQL Trigger to Insert Deleted Record in New Table

PL/SQL Trigger to Insert Deleted Record in New Table: When any record gets deleted from STUDENT table the that RECORD…

add comment

PL/SQL Cursor to Find Total Salary in Department

PL/SQL Cursor to Find Total Salary in Department: declare dno number; vdno number; totsalary number; cnt number; cursor tot_sal(vdno number)…

add comment

PL/SQL Cursor to Display Names in Uppercase

PL/SQL Cursor to Display Names in Uppercase: declare cursor upr is select upper(ename)ename from emp order by empno; begin for…

add comment