Header Ads Widget

Responsive Advertisement

Recent posts

View all
Module 09: Creating Compound, DDL, and Event Database Triggers PL/SQL Programming

Module 09: Creating Compound, DDL, and Event Database Triggers

dbskool November 12, 2023

Creating Compound, DDL, and Event Database  Triggers 01. What Are Triggers? Triggers: a. A trigger is a PL/SQL block that is stored in the databa…

Read more
Module 08: Creating Triggers PL/SQL Programming

Module 08: Creating Triggers

dbskool November 12, 2023

Creating Triggers 01. What are Autonomous Transactions?  Autonomous Transactions: a. Are independent transactions started by another main transac…

Read more
Module 07: Design Considerations for PL/SQL Code PL/SQL Programming

Module 07: Design Considerations for PL/SQL Code

dbskool November 12, 2023

Design Considerations for PL/SQL Code 01. What is Local Subprogram? Ans: A local subprogram is a PROCEDURE or FUNCTION defined at the end of the de…

Read more
Module 06: Using Dynamic SQL PL/SQL Programming

Module 06: Using Dynamic SQL

dbskool November 12, 2023

Using Dynamic SQL 01. Write down the Execution Flow of SQL. All SQL statements go through some or all of the following stages:  a. Parse. b. Bi…

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