Module 01: Creating Procedures
Creating Procedures 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( …
Creating Procedures 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( p_dspt_name VARCHAR2 DEFAULT ‘Placeholder’, p_location VARCH…
Read moreManaging Dependencies 01. What is local dependency? In the case of local dependencies, the objects are on the same node in the same database. The…
Read moreManaging PL/SQL Code 01. What Is Conditional Compilation? Enables you to customize the functionality in a PL/SQL application without removing any…
Read moreUsing the PL/SQL Compiler 1. What Is a Compound Trigger? A single trigger on a table that allows you to specify actions for each of the followin…
Read moreCreating 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 moreCreating Triggers 01. What are Autonomous Transactions? Autonomous Transactions: a. Are independent transactions started by another main transac…
Read moreDesign 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 moreCreating Procedures 01. Examine this code: CREATE OR REPLACE PROCEDURE add_dept ( …
Follow Us