100%(2)2 out of 2 people found this document helpful
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 employeesEND 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 blocksWhich if the following is NOT a benefits of using modular program constructs?
PROG-113A / ►Week 18: Designing PL/SQL / ►Short Quiz 14Which of the following is the syntax to open a cursor varialAnswer: OPEN cursor_variable_nameFOR 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 / ►