Write a program in PL/SQL to create an explicit cursor with for loop.
DECLARE CURSOR emp_cur_detail IS SELECT department_name, d.department_id, first_name, last_name, job_id, salary FROM departments d join employees e ON e.department_id = d.department_id WHERE job_id = 'ST_CLERK' AND salary > 3200; BEGIN FOR emp_rec IN emp_cur_detail LOOP dbms_output.Put_line('Name: ' ||emp_rec.first_name ||' ' ||emp_rec.last_name ||Chr(9) ||'Department Name: ' ||emp_rec.department_name ||Chr(9) ||'Department ID: ' ||emp_rec.department_id ||Chr(9) ||'Job ID: ' ||emp_rec.job_id ||Chr(9) ||'Salary: ' ||emp_rec.salary); END LOOP; END; /
Sample Output:
SQL> / Name: Laura Bissot Department Name: Shipping Department ID: 50 Job ID: ST_CLERK Salary: 3300 Name: Trenna Rajs Department Name: Shipping Department ID: 50 Job ID: ST_CLERK Salary: 3500 Name: Renske Ladwig Department Name: Shipping Department ID: 50 Job ID: ST_CLERK Salary: 3600 Name: Jason Mallin Department Name: Shipping Department ID: 50 Job ID: ST_CLERK Salary: 3300 PL/SQL procedure successfully completed.
total answers (1)
start bookmarking useful questions and collections and save it into your own study-lists, login now to start creating your own collections.
Sample Output:
need an explanation for this answer? contact us directly to get an explanation for this answer