Which of the following is the syntax to fetch from a cursor variable Answer

Which of the following is the syntax to fetch from a

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?
Image of page 25
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_employee Evaluate 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.
Image of page 26
Given the answer in item __________, which of the folllowing stored procedure will display the employee id and salary of Steven King?
Image of page 27
Image of page 28

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture