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