100%(1)1 out of 1 people found this document helpful
This preview shows page 25 - 28 out of 70 pages.
Which of the following is the syntax to fetch from a cursor variable?Fetch into a record when fetching from a cursor.Which of the following is the syntax to close a cursor?This is a subset of an existing data type that may place a constraint on its base type.Which of the following rules is INCORRECT about cursor variables?
Use column aliases in cursors for calculated columns fetched into records declared with %COLUMNTYPE.PROG-113A / ►Week 18: Designing PL/SQL / ►Learning Activity 14Which of the following rules is INCORRECT about cursor variables?Which of the following describes weak REF CURSOR?Restrictive, specifies a RETURN type, associates only with type-compatible queries are description of a ________________.Which of the following is INCORRECT about the guidelines for cursor design?This is a subset of an existing data type that may place a constraint on its base type.PROG-113A / ►Week 17: / ►Short Quiz 13Evaluate the following PL/SQL.CREATE OR REPLACE PROCEDURE query_employee(p_id IN employees.employee_id%TYPE,p_name OUT employees.last_name%TYPE,p_salary OUT employees.salary%TYPE) ISBEGIN SELECT last_name, salary INTO p_name, p_salaryFROM employeesWHERE employee_id = p_id;END query_employeeEvaluate the following PL/SQL. Which of the following will line creates an error?CREATE OR REPLACE PROCEDURE query_emp(p_department_id IN employees.department_id%TYPE,p_name OUT employees.last_name%TYPE,p_salary OUT employees.salary%TYPE)ISBEGINSELECT last_name, salary, department_id INTO p_name, p_salary, p_department_idFROM employeesWHERE salary >= p_salary AND department_id = p_department_id ;END query_emp;These are local variables declared in the parameter list of a subprogram specification.
Given the answer in item __________, which of the folllowing stored procedure will display the employee id and salary of Steven King?