Plastname in pfirstname in

This preview shows page 26 - 28 out of 82 pages.

(p_last_name IN employees.last_name%TYPE,p_first_name IN employees.first_name%TYPE,p_employee_id OUT employees.employee_id%TYPE,p_salary OUT employees.salary%TYPE) ISBEGINSELECT employee_id, salary INTO p_employee_id, p_salaryFROM employees END query_emp;What is the default parameter mode when no mode is specified? Week 16: Creating Procedures / Learning Activity 13Procedure can be stored in the database as a schema object. The PL/SQL code block helps modularize code by using: Which of the following command is used to create a stand-alone procedure that is stored in the Oracle database? Which of the folllowing does NOT describes subprogram? iv. Can take parametersv. Unnamed PL/SQL blocks Which if the following is NOT a benefits of using modular program constructs?
Image of page 26
PROG-113A / Week 18: Designing PL/SQL / Short Quiz 14 Which of the following is the syntax to open a cursor varial Answer: OPEN cursor_variable_name FOR select_statement; Which of the following is the syntax to define a REF CURSOR type? Evaluate the following. What will be the output? 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 /
Image of page 27
Image of page 28

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture