Course Duration
40 HOURS
About Oracle 10g
Oracle Database 10g was the first database designed for grid computing, the most flexible and
cost-effective way to manage enterprise information. It cut costs of management while providing the highest
possible quality of service.
Course Contents
Oracle 10gLanguage Features
- Understanding PL/SQL
- Structure of a PL/SQL program Block
- PL/SQL from Interactive Tools
- Generating Output with in SQL Plus
Declare Clause
- Declare Simple Types
- Complex Types
- Type ... Table
- Type ... Record
Begin Clause
- About the Begin Clause
- Performing Data Manipulation
- Logic Control & Branching
- If-Then-Else
- Case
Exception Clause
- About the Exception Clause
- Isolating The Specific Exception
- Pragma Exception_INIT
- SQL%ROWCOUNT & SELECT...INTO
Explicit Cursors
- About Explicit Cursors
- Advanced Cursor Techniques
Advanced Programming : Nested Blocks
Advanced Programming : Declared Subprograms
Introducing Database Program Units
- About DataBase Program Units
- Types of PL/SQL Program Units
- Types of Stored Program Units
- Advantages of using Stored Program Units
- Development Tools
Creating Stored Procedures & Functions
- About Stored Procedures & Functions
- Creating Procedures & Functions
- Executing Procedures & Functions
- Handling Compilation Errors
Maintaining Stored Procedures & Functions
- Recompiling & Dropping Programs
- Data Dictionary Storage
- Managing Dependencies
Creating & Maintaining Packages
- About Packages
- Creating Packages
- Advanced Programming Techniques
- Maintaining Packages
Advanced Cursor Techniques
- Using Cursor Variables
- Using Cursor Expressions
Using System-supplied Packages
- DBMS_OUTPUT()
- UTL_FILE()
Creating Database Triggers
- About Database Triggers
- Statement – Level Triggers
- Row-Level Triggers
- Examples of Triggers
- Instead of Triggers
- Employing Triggers within an application
Maintaining Database Triggers
- Call Syntax
- Multiple Triggers Per event
- Trigger Maintenance Tasks
- Show Errors Trigger
- Drop Trigger
- Alter Trigger
- Handling Mutating Table Issues
Implementing System Event Triggers
- What are System Event Triggers?
- Defining the Scope
- Available System Events
- System Event Attributes
Register Now
