Intermediate
12-7. | Write a block of code that uses a strong REF CURSOR to retrieve all the rows from the employee table and calls the double_salary program for each employee as shown: PROCEDURE double_salary ( id_in IN employee.employee_id%TYPE, sal_in IN employee.salary%TYPE); |
12-8. | Given the following data element definitions: CREATE TABLE funny_democracy (
work_on_election_day DATE,
only_two_parties NUMBER
);
DECLARE
TYPE very_funny_t IS RECORD (
first_tuesday DATE,
dems_and_repubs NUMBER := 2);
TYPE ours_cvt IS REF CURSOR RETURN funny_democracy%ROWTYPE;
the_finest_cv ours_cvt;Which of the following record declarations can validly be used to hold a row fetched from the_finest_cv cursor variable?
|
12-9. | Which of the following statements correctly identify the differences between strong and weak REF CURSORs?
|