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

PL/SQL Cursor to Display Names in Lowercase

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

add comment

PL/SQL Cursor to Display Last Five Records

PL/SQL Cursor to Display Last Five Records: declare tot number; cnt number; rcnt number; cursor last_five_record is select * from…

add comment

PL/SQL Cursor to Display Record from One Number to Another

PL/SQL Cursor to Display Record from One Number to Another: declare cursor rec_print is select * from emp; frno number;…

add comment

PL/SQL Cursor to Display Record having Third Highest Salary

PL/SQL Cursor to Display Record having Third Highest Salary: declare cursor third_hsal is select * from student order by salary…

add comment

PL/SQL Cursor to Display Last Five Records having Highest Salary

PL/SQL Cursor to Display Last Five Records having Highest Salary: declare cursor hsal is select * from student order by…

add comment

PL/SQL Cursor Example with Parameter

PL/SQL Cursor Example with Parameter: declare vno number; cursor sname(vno number) is select * from student where id=vno; begin vno:=:vno;…

add comment

PL/SQL Cursor to Update Table Records

PL/SQL Cursor to Update Table Records: declare cursor cupd is select * from student for update; begin for i in…

add comment

PL/SQL Cursor to Display Records in Even Numbers

PL/SQL Cursor to Display Records in Even Numbers: declare cursor s_even is select * from student; cnt number; rcnt number;…

add comment