DBSkool Header Image Background

Category: PL/SQL_ExpressivePage 1 of 3

Dependency

1. What is local dependency? In the case of local dependencies, the objects are on the same node in the same database. The Oracle server automatically manages all…

Applications for Triggers

1. What Is Conditional Compilation? Enables you to customize the functionality in a PL/SQL application without removing any source code. 2. Write down the benefits of Conditional Compilation….

Creating Triggers

1. What Is a Compound Trigger? A single trigger on a table that allows you to specify actions for each of the following four timing points: a. Before…

Manipulating Large Objects

1. What is LOB? A LOB is a data type that is used to store large, unstructured data such as text, graphic images, video clippings, and so on….

Managing Dependencies

1. What is dependency? Dependency means Some objects reference other objects as part of their definitions. 2. Write some dependent and referenced objects Some dependent objects are- •…

Design Considerations for PL/SQL Code

1. What is local subprograms? A local subprogram is a procedure or function defined in the declarative section. 2. Write the benefits of local subprograms. The benefits of…

Using Dynamic SQL

1. Write the steps to Process SQL statements All SQL statements go through various stages. The key stages are following – • Parse • Bind • Execute •…

Utilizing Oracle-Supplied Packages in Application Development

1. What are oracle-supplied packages? The oracle supplied packages are provided with the oracle server and extend the functionality of the database. 2. Write some oracle-supplied packages name….

Using More Package Concepts

1. what is overloading? The overloading feature in PL/SQL enables us to create two or more subprograms with the same name. It requires that the subprogram’s formal parameters…

Creating Packages

1. What is Package? PL/SQL packages are group logically related components. -PL/SQL types -variables, data structures and exceptions -subprograms: procedures & functions 2. Write the parts of package….