Working with Packages 01. What is Overloading Subprograms in PL/SQL? Overloading: a. Enables you to create two or more subprograms with the same …
Read moreCreating Packages 01. What Are PL/SQL Packages? A package is a schema object that groups logically related PL/SQL types, variables, and subprogram…
Read moreCreating Functions 01. What is Function? Function: a. Is a named PL/SQL block that returns a value. b. Can be stored in the database as a schem…
Read moreCreating Procedures 01. Write down the process of creating a Layered Subprogram Design. Create subprogram layers for your application. a. Data a…
Read moreCreating Stored Procedures and Functions 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, …
Read moreHandling Exceptions 01. Which two conditions in a PL/SQL block cause an exception error to occur? (Choose two) a. Select statement does not retur…
Read moreUsing Explicit Cursors 01. You want to create a cursor that can be used several times in a block. Selecting a different active set each time that i…
Read more
Follow Us