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