• Procedures in PL/SQL :

• STORED PROCEDURES

• PROCEDURE with Parameters (IN,OUT  and IN OUT)

• POSITIONAL Notation and NAMED Notation

• Procedure with Cursors

• Dropping a Procedure

• Difference between Procedures and Functions

• User Defined Functions

• Nested Functions

• Using stored function in SQL statements

• Creating PACKAGE Specification and  Package Body

• Private and Public Objects in PACKAGE

Types of exceptions :

• User Defined Exceptions

• Pre Defined Exceptions

• RAISE_APPLICATION_ERROR

• PRAGMA_AUTONOMOUS_TRANSACTION

• SQL Error Code Values

• Types of Triggers

• Row Level Triggers

• Statement Level Triggers

• DDL Triggers

• Trigger Auditing

• PL/SQL file I/O (Input/Output)

• Using UTL_FILE Package

• What is Object Technology ?

• OOPS-Object Instances

• Creation of objects

• Creating User Defined Data Types

• Creating Object Tables

• Inserting rows in a table using Objects

• Retrieving data from Object based Tables

• Calling a Method

• Indexing Abstract Data type Attributes

• Large Objects (LOBS)

• Creating Tables-LOB

• Working with LOB values

• Inserting, Updating & Deleting Values in LOBs

• Populating Lobis DBMS_LOB Routines

• Using B-FILE

• Advantages of collection

• Ref cursor (Dynamic Cursor)

• Weak ref cursor

• Strong ref cursor

• Nested Tables VARRAYS or VARYING arrays

• Creating tables using nested tables

• Inserting, updating & deleting Nested

• Table records

• Nested table in PL/SQL

• Introduction to Oracle Database Architecture

• Physical structures Logical structures

• DB Memory Structures Background Process

• 2 Tire, 3 Tire, N-Tier Architecture

• 9i Joines

• New Date function

• Rename column

• Inner Join/Natural Join

• Left Outer Join/Right Outer Join

• Full Outer Join

• Multiple Inserts

• Insert All Command

• Merge statement

• NVL2(), NULLIF(), COALESCE()

• CASE expression of Select Command

• Temporary Tables/Global Tables

• New Function EXTRACT()

• Autonomous Traction

• Pragma _ Autonomous_ Transaction()

• Bulk Collect

• About Flashback Queries

• Dynamic SQL

• New data types, Flash back Command

• Purge Command, Recycle Bin

• Regular expressions, DML Error Logging

• Data Pump, Virtual Columns

• Read only tables, Cross tab Views using

• Pivot/Unpivot operators, Follows Clause

• Compound triggers, New data types

• Database

• Tablespace

• Types of tablespaces

• Data files