Write a program in PL/SQL to create a cursor displays the name and salary of each employee in the EMPLOYEES table whose salary is less than that specified by a passed-in parameter value
Write a program in PL/SQL to create a cursor displays the name and salary of each employee in the EMPLOYEES table whose salary is less than that specified by a passed-in parameter value.
DECLARE
var_record employees%ROWTYPE;
CURSOR cur_test (max_sal NUMBER) IS
SELECT * FROM employees WHERE salary < max_sal;
BEGIN
OPEN cur_test(5800);
LOOP
FETCH cur_test INTO var_record;
EXIT WHEN cur_test%NOTFOUND;
DBMS_OUTPUT.PUT_LINE('Name: ' || var_record.first_name || chr(9)||' salary: '
|| var_record.salary);
END LOOP;
CLOSE cur_test;
END;
/
Sample Output:
SQL> /
Name: David salary: 4800
Name: Valli salary: 4800
Name: Diana salary: 4200
Name: Alexander salary: 3100
Name: Shelli salary: 2900
Name: Sigal salary: 2800
Name: Guy salary: 2600
Name: Karen salary: 2500
Name: Julia salary: 3200
Name: Irene salary: 2700
Name: James salary: 2400
Name: Steven salary: 2200
Name: Laura salary: 3300
...
Sample Output:
need an explanation for this answer? contact us directly to get an explanation for this answer