Module 09: Creating Compound, DDL, and Event Database Triggers
Creating Compound, DDL, and Event Database Triggers 01. What Are Triggers? Triggers…
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 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 moreUsing 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 moreUsing Oracle-Supplied Packages in Application 01. What are The Oracle-supplied packages? The Oracle-supplied packages: a. Are provided with the…
Read moreWorking 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 Compound, DDL, and Event Database Triggers 01. What Are Triggers? Triggers…
Follow Us