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

  • pl/sql

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.
هل كان المحتوى مفيد؟

معلومات ذات صلة

تبحث عن مدرس اونلاين؟

محتاج مساعدة باختيار المدرس الافضل؟ تواصل مع فريقنا الان لمساعدتك بتأمين افضل مدرس
ماهو التخصص الذي تبحث عنه؟
اكتب هنا...