45 Days
8 am to 10 am (IST)
Online
▪ Overloading, forward declarations, and initialization block▪ Persistent State of Packages
▪ Using Oracle-Supplied Packages in Application Development▪ DBMS_OUTPUT, UTL_FILE and UTL_MAIL Packages
▪ Standardizing Constants and Exceptions, Autonomous Transactions▪ NOCOPY and PARALLEL_ENABLE Hints, DETERMINISTIC Clause▪ RETURNING Clause, Using Bulk Binding
▪ Defining Triggers▪ DML Triggers▪ Using OLD and NEW Qualifiers , INSTEAD OF Triggers▪ The Status of a Trigger
▪ What Is a Compound Trigger?▪ Trigger Restrictions on Mutating Tables▪ Creating Triggers on DDL Statements, Event Triggers