﻿ PL/SQL Cursor: Create an explicit cursor with for loop - w3resource

# PL/SQL Cursor Exercises: Create an explicit cursor with for loop

## PL/SQL Cursor: Exercise-13 with Solution

Write a program in PL/SQL to create an explicit cursor with for loop.

Sample Solution:

PL/SQL Code:

``````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.
```

Flowchart:

Improve this sample solution and post your code through Disqus

What is the difficulty level of this exercise?

﻿

Inviting useful, relevant, well-written and unique guest posts