Header Ads Widget

Module 05: Using Oracle-Supplied Packages in Application PL/SQL Programming

Module 05: Using Oracle-Supplied Packages in Application

dbskool November 12, 2023

Using Oracle-Supplied Packages in Application  01. What are The Oracle-supplied packages? The Oracle-supplied packages:  a. Are provided with the…

Read more
Module 04: Working with Packages PL/SQL Programming

Module 04: Working with Packages

dbskool November 12, 2023

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 more
Module 03: Creating Packages PL/SQL Programming

Module 03: Creating Packages

dbskool November 12, 2023

Creating Packages 01. What Are PL/SQL Packages?  A package is a schema object that groups logically related PL/SQL types, variables, and subprogram…

Read more
Module 02: Creating Functions PL/SQL Programming

Module 02: Creating Functions

dbskool November 12, 2023

Creating 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 more
Module 01: Creating Procedures PL/SQL Programming

Module 01: Creating Procedures

dbskool November 12, 2023

Creating Procedures 01. Write down the process of creating a Layered Subprogram Design. Create subprogram layers for your application.  a. Data a…

Read more
Module 09: Creating Stored Procedures and Functions PL/SQL Fundamental MCQ

Module 09: Creating Stored Procedures and Functions

dbskool November 12, 2023

Creating Stored Procedures and Functions 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, …

Read more
Module 08: Handling Exceptions PL/SQL Fundamental MCQ

Module 08: Handling Exceptions

dbskool November 12, 2023

Handling 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 more