Intermediate
Q: | |
12-7. | Here is one possible implementation: DECLARE
TYPE emp_cvt IS REF CURSOR RETURN employee%ROWTYPE;
employees emp_cvt;
one_employee employees%ROWTYPE;
BEGIN
OPEN employees FOR SELECT * FROM employee;
LOOP
FETCH employees INTO one_employee;
EXIT WHEN employees%NOTFOUND;
double_salary (one_employee.employee_id, one_employee.salary);
END LOOP;
CLOSE employees;
END;
/ |
Q: | |
12-8. | Here are the rules to keep in mind in solving this problem:
The declarations are:
|