PL/SQL: Cursor Management

Cursor Management. 

Types of Cursors. 

Cursor Attributes. 

Explicit Cursor and Implicit FOR Loops. 

How cursor will work.  

Write a PL/SQL Cursor to Hike the employee salary as following conditions   i).If Employee salary is 0 to 1000 hike 5%.   ii).If Employee salary is 1001 to 2000 hike 25%.   iii).Other then this two conditions hike 35% of the all employees. (Display the Employee name,hiked sal as a outpu). 

Write a PL/SQL Cursor to Hike the employee salary following conditions.  i).If Employee job is ‘CLERK’ hike the salary 100.  ii).If Employee job is ‘SALESMAN’ hike the salary 200.  iii).Other then the this two conditions hike the salary 300. (Display the output as employee name, job and updated salary). 

Write a PL/SQL Cursor to Hike the commission with the following conditions.  i).If commission is null value give the commission as 300.  ii).If commission is 0 give the commission as 250.  iii).Other then this two conditions hike the 35%. (Display the output as Employee name, Updated Commission.). 

Write a PL/SQL Cursor to display Employee number, Employee name, Salary, Basic HRA, DA, PF, Gross Salary and Department of employees and display the number of employees are eligible for the PF. (Hint: Those Employees having a salary above 4000 is eligible for the PF.). 

Write a PL/SQL Cursor to check the user authentication.Cursor with For loops.Parametric cursor. Methods of Opening a parametric Cursor.  

Write a PL/SQL Cursor to display the employee details according to the department table department number. Every department details should be separate with ‘--------------’. 

Write a PL/SQL Cursor to display the employee details according to the department table department number. Every department details should be following conditions.   i)  If Employee HRA salary is basic*0.45.  ii) If Employee  DA salary is basic*0.35.  iii)If Employee PF salary is basic*0.15.FOR UPDATE Clause And Using WHERE CURRENT OF clause. 

Write a PL/SQL Program to display the employee details and any employees work in 50 department remove that employees and display the removing employees with locking system. 

Write a PL/SQL Program to display the department number, department name, location and number of employees. The department which is having more than three employees. Dynamic cursor Ref Cursor or Cursor Variable.Types of cursor variable. 

Write a PL/SQL Cursor to display the different active sets at run time according to the department number.  i).If department number 10 display employee name, job, salary of the 10 department.  ii).If department number 20 display employee name, job, salary of the 20 department.    iii).Other than this 2 departments display employee name, salary, department number of other departments.