Oracle cursor: Query and print employee name and salary

Oracle cursor: Query and print employee name and salary

-- Query and print employee name and salary -- set serveroutput on/* 1. cursor attribute % found: true if the record is obtained; otherwise false; % notfound: */declare -- Define a cursor cemp is select ename, sal from emp; -- Define the corresponding variable pename emp for the cursor. ename % type; psal emp. sal % type; begin -- open the cursor open cemp; loop -- take the order behind the record into and define the ename behind the cursor. sal has the same order as fetch cemp into pename and psal; -- think: 1. When does the loop exit? 2. fetch may not necessarily get the record -- exit when does not get the record exit when cemp % notfound; -- print the obtained record dbms_output.put_line (pename | 'salary is '| psal ); end loop; -- close the cursor to close cemp; end ;/