Oracle PL SQL

 

About PL/SQL
Benefits of PL/SQL 1
Benefits of PL/SQL 2
Benefits of PL/SQL 3
PL/SQL Block Structure
Block Types
Use of Variables
Types of Variables
Declaring PL/SQL Variables
Naming Rules
Variable Initialization and Keywords
Scalar Data Types
The %TYPE Attribute
Declaring Boolean Variable
Composite Data Type
LOB Data Type Variable
Bind Variables
Referencing Non-PL/SQL Variables
DBMS_OUTPUT.PUT_LINE
Practice
PL/SQL Block Syntax and Guidelines 1
PL/SQL Block Syntax and Guidelines 2
Commentiong Code
SQL Functions in PL/SQL
Data Type Conversion
Variable Scope
Qualify an Identifier
Operators In PL/SQL
Programming Guidelines
Practice 1
Practice 2
SQL Statements in PL/SQL
SELECT Statement in PL/SQL
Retrieving Data in PL/SQL
Naming Conventions
Manipulating Data Using PL/SQL 1
Manipulating Data Using PL/SQL 2
SQL Cursor
Transaction Control Statements
Practice 1
Practice 2
Controlling PL/SQL Flow Of Execution
Compound IF Statements 1
Compound IF Statements 2
CASE Expression
Handling Nulls
Logic Tables
Iterative Control : LOOP Statement
EXIT Statement
WHILE Loops
FOR Loop
Guidelines While Using Loops
Nested Loops and Lables
Practice
Record and Table Data Type
Defining and Declaring PL/SQL Record
The %ROWTYPE Attribute 1
The %ROWTYPE Attribute 2
INDEX BY Tables
Using INDEX BY Table Methode'
INDEX BY Table of Records
Practice 1
Practice 2
Implicit and Explicit Cursors
Declaring The Cursor
Opening The Cursor
Fetching Data From The Cursor
Closing The Cursor
Explicit Cursor Attributes 1
Explicit Cursor Attributes 2
Cursors and Records
Cursor FOR Loop
Practice
Cursors With Parameters
The FOR UPDATE Clause
The WHERE CURRENT OF Clause
Cursor With Subquery
Practice
Introduction
Trapping Exceptions
Trapping Predefined Oracle Sever Errors
Trapping Nonpredefined Oracle Sever Errors
Functions For Trapping Exceptions
Trapping User-Defined Exceptions
Practice 1
Practice 2
PL/SQL Block Structure
Anonymous Block
Subprograms
What Is a Procedure?
Developing Procedures
Formal Versus Actual Parameters
Procedural Parameter Modes
Creating Procedures With Parameters
In Parameter Example
Out Parameter Example
Viewing Out Parameters
In Out Parameters
Methods For Passing Parameters
DEFAULT Option For Parameters
Declaring Subprograms
Invoking Procedures
Handled Exceptions
Unhandled Exceptions
Removing Procedure
Benefits of Subprograms
Practicce 1
Practicce 2
Stored Functions
How To Create Stored Functions
Executing Functions
Invoking User Defined Functions 1
Invoking User Defined Functions 2
Removing Functions
Procedure or Function
Practicce 1
Practicce 2
System and Object Privilege
Granting Access To Data
Managing Stored PL/SQL Objects 1
Managing Stored PL/SQL Objects 2
Managing Stored PL/SQL Objects 3
Debuging PL/SQL Program Units
Practice 1
Practice 2
Package Overview
 Components of a Package
Developing a Package
Creating The Package Body
Public and Private Constructs
Invoking Package Constructs
Declaring a Bodiless Package
Guidelines For Developing Package
Practice 1
Practice 2
Overloading
Using Forward Declaration
Creating One-Time-Only Procedure
invoking a user defined package function
persistent state of package variables
controlling the persistent state of a package cursor
PL/SQL tables and records in packages
practice
introduction
using Native Dynamic SQL
steps to process SQL statement
using DBMS_SQL Package
using the EXECUTE IMMEDIATE Statement
using the DBMS_DDL Package
using DBMS_JOB for scheduling
submitting jobs
changing job characteristics
Running,Removing,and Breaking jobs
viewing information on submitted jobs
using the DBMS_OUTPUT Package
interacting with operating system files
what is the UTL_FILE package
UTL_FILE procedures and functions
FOPEN and IS_OPEN functions 1
FOPEN and IS_OPEN functions 2
UTL_HTTP package
using UTL_TCP package
Practice 1
Practice 2
Practice 3
what is a LOB ?
contrasting LONG and LOB data types
Anatomy of a LOB
Internal LOBs
what are BFILEs ?
securing BFILEs
A New Database Object : DIRECTORY
Guidelines for creating DIRECTORy Objects
Managing BFILEs
BFILENAME function
Loading BFILEs
migrating from LONG to LOB
DBMS_LOB package 1
DBMS_LOB package 2
DBMS_LOB.READ AND DBMS_LOB.WRITE
Adding LOB columns to a table 
Updating LOB Objects
Selecting CLOB Objects
Removing LOBs
Temporary LOBs
practice 1
practice 2
Types of Triggers
Guidelines for Designing Triggers
Creating DML Trigger
DML Trigger components 1
DML Trigger components 2
Syntax for creating DML Statement Trigger
creating a DML ROW Trigger
using OLD and NEW qualifiers
Restricting Row Trigger
INSTEAD OF Trigger
Database Trigger and Stored Procedure
Database Trigger and Form Builder Trigger
Managing Triggers - Drop Triggers
Practice 1
Practice 2
Creating Database Triggers
Creating Triggers on DDL Statement
Creating Triggers on System Events
LOGON and LOGOFF Trigger Examples
Call Statement
Reading Data From  a Mutating Table
Implementing Triggers
controlling security with databse triggers
Auditing by using a Trigger
Enforcing Referential Integrity within the server
benefits of database triggers
Managing Triggers 
Viewing Trigger Information
Using USER_TRIGGERS
Practice 1
Practice 2
Understanding Dependencies
Dependencies
Local Dependencies 1
Local Dependencies 2
Displaying Direct Dependencies
Another Scenario of local dependencies
understanding Remote Dependencies
Concepts of remote dependencies
Remote Dependencies and Time Stamp Mode
Local Procedures Referencing Remote Procedures
Signature Mode 
Recompiling a PL/SQL Program Unit
Unsuccessfull Recompilation
Packages and Dependencies
Practice