Write a program in PL/SQL to fetch the first three rows of a result set into three records using Same explicit cursor into different variables.
DECLARE CURSOR empcur IS SELECT e.first_name,e.job_id, j.job_title FROM employees e, jobs j WHERE e.job_id = j.job_id AND e.manager_id = 148 ORDER BY last_name; emp_job1 empcur%ROWTYPE; emp_job2 empcur%ROWTYPE; emp_job3 empcur%ROWTYPE; BEGIN OPEN empcur; FETCH empcur INTO emp_job1; FETCH empcur INTO emp_job2; FETCH empcur INTO emp_job3; CLOSE empcur; DBMS_OUTPUT.PUT_LINE(Rpad(emp_job1.first_name, 25, ' ')||emp_job1.job_title || ' (' || emp_job1.job_id || ')'); DBMS_OUTPUT.PUT_LINE(Rpad(emp_job2.first_name, 25, ' ')||emp_job2.job_title || ' (' || emp_job2.job_id || ')'); DBMS_OUTPUT.PUT_LINE(Rpad(emp_job3.first_name, 25, ' ')||emp_job3.job_title || ' (' || emp_job3.job_id || ')'); END; /
Sample Output:
SQL> / Elizabeth Sales Representative (SA_REP) Harrison Sales Representative (SA_REP) Tayler Sales Representative (SA_REP) 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