ãÌãæÚÉ 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