001 125 Oracle PLSQL- Before You Start

002 125 Oracle PLSQL- Course Agenda

003 125 Oracle PLSQL- Overview of PLSQL 1

004 125 Oracle PLSQL- Overview of PLSQL 2

005 125 Oracle PLSQL- Overview of PLSQL 3

006 125 Oracle PLSQL- Declaring PLSQL Variables 1

007 125 Oracle PLSQL- Declaring PLSQL Variables 2

008 125 Oracle PLSQL- Declaring PLSQL Variables 3

009 125 Oracle PLSQL- Declaring PLSQL Variables 4

010 125 Oracle PLSQL- Declaring PLSQL Variables 5

011 125 Oracle PLSQL- Writing executable statements 1

012 125 Oracle PLSQL- Writing executable statements 2

013 125 Oracle PLSQL-Interacting with Oracle DB Server 1

014 125 Oracle PLSQL-Interacting with Oracle DB Server 2

015 125 Oracle PLSQL- IF Statement- ركز هنا

016 125 Oracle PLSQL- Case Statement VS Case Expression

017 125 Oracle PLSQL- Handling Nulls in IF Statement

018 125 Oracle PLSQL- Basic Loop

019 125 Oracle PLSQL- While Loop

020 125 Oracle PLSQL- FOR Loop

021 125 Oracle PLSQL- Nested Loops & Labels

022 125 Oracle PLSQL- Continue Statement

023 125 Oracle PLSQL- PLSQL Records Part 1

024 125 Oracle PLSQL- PLSQL Records Part 2

025 125 Oracle PLSQL- Index by Tables-Associative Arrays 1

026 125 Oracle PLSQL- Index by Tables-Associative Arrays 2

027 125 Oracle PLSQL- Index by Tables-Assosiative Arrays 3

028 125 Oracle PLSQL- Nested tables

029 125 Oracle PLSQL- Varray

030 125 Oracle PLSQL- Using explicit cursors 1

031 125 Oracle PLSQL- Using explicit cursors 2

032 125 Oracle PLSQL- Using explicit cursors 3 ( FOR)

033 125 Oracle PLSQL- Using explicit cursors 4

034 125 Oracle PLSQL- Using explicit cursors 5

035 125 Oracle PLSQL- Handling Exceptions Introduction

036 125 Oracle PLSQL- Handling Exceptions Real Examples

037 125 Oracle PLSQL- Handling Exceptions Non- Predefined

038 125 Oracle PLSQL- Handling Exceptions Non- Predefined Practice

039 125 Oracle PLSQL- Handling Exceptions Programmer Exceptions

040 125 Oracle PLSQL-Creating Procedure Introduction

041 125 Oracle PLSQL-Creating Procedure Practice

042 125 Oracle PLSQL-Creating Procedure OUT Parameters

043 125 Oracle PLSQL-Creating Procedure IN OUT Parameters

044 125 Oracle PLSQL-Creating Procedure Passing Parameters

045 125 Oracle PLSQL-Creating Procedure Handling Exceptions

046 125 Oracle PLSQL- Creating Functions 1

047 125 Oracle PLSQL- Creating Functions 2

048 125 Oracle PLSQL- Creating Functions 3

049 125 Oracle PLSQL- Creating Functions 4

050 125 Oracle PLSQL- Creating Packages 1

051 125 Oracle PLSQL- Creating Packages 2

052 125 Oracle PLSQL- Creating Packages 3

053 125 Oracle PLSQL- Creating Packages 4

054 125 Oracle PLSQL- Working with Packages Overloading

055 125 Oracle PLSQL- Working with Packages Overloading Standard Program

056 125 Oracle PLSQL- Working with Packages Forward Declaration

057 125 Oracle PLSQL- Working with Packages Persistent State

058 125 Oracle PLSQL- Working with Packages Persistent Cursor

059 125 Oracle PLSQL- Working with Packages Array Example

060 125 Oracle PLSQL- Supplied Packages Introduction

061 125 Oracle PLSQL- Supplied Packages DBMS OUTPUT

062 125 Oracle PLSQL- Supplied Packages UTL FILE 1

063 125 Oracle PLSQL- Supplied Packages UTL FILE 2

064 125 Oracle PLSQL- Supplied Packages UTL FILE 3

065 125 Oracle PLSQL- Supplied Packages UTL MAIL 1

066 125 Oracle PLSQL- Supplied Packages UTL MAIL 2

067 125 Oracle PLSQL- Dynamic SQL Introduction

068 125 Oracle PLSQL- Dynamic SQL Execute Immediate 1

069 125 Oracle PLSQL- Dynamic SQL Execute Immediate 2

070 125 Oracle PLSQL- Dynamic SQL Execute Immediate 3

071 125 Oracle PLSQL- Dynamic SQL REF Cursor

072 125 Oracle PLSQL- Dynamic SQL More Examples

073 125 Oracle PLSQL- Dynamic SQL DBMS SQL

074 125 Oracle PLSQL- Design consideration Standardizing

075 125 Oracle PLSQL- Design consideration Definer’s & Invoker’s Rights

076 125 Oracle PLSQL- Design consideration AUTONOMOUS TRANSACTION

077 125 Oracle PLSQL- Design consideration NOCOPY Hint 1

078 125 Oracle PLSQL- Design consideration NOCOPY Hint 2

079 125 Oracle PLSQL- Design consideration parallel enable result cache

080 125 Oracle PLSQL- Design consideration Bulk Binding 1

081 125 Oracle PLSQL- Design consideration Bulk Binding 2

082 125 Oracle PLSQL- Design consideration Bulk Binding 3

083 125 Oracle PLSQL- Design consideration Bulk Binding 4

084 125 Oracle PLSQL- Design consideration Bulk Binding 5

085 125 Oracle PLSQL- Design consideration Bulk Binding 6

086 125 Oracle PLSQL- Creating Triggers Introduction

087 125 Oracle PLSQL- Creating Triggers Statement Level

088 125 Oracle PLSQL- Creating Triggers Row Level (1)

089 125 Oracle PLSQL- Creating Triggers Row Level (2)

090 125 Oracle PLSQL- Creating Triggers Trigger Firing Sequence

091 125 Oracle PLSQL- Creating Triggers Default Value

092 125 Oracle PLSQL- Creating Triggers Instead of Triggers

093 125 Oracle PLSQL- Creating Triggers follows Statement

094 125 Oracle PLSQL- Creating Triggers Compound triggers 1

095 125 Oracle PLSQL- Creating Triggers Compound triggers 2

096 125 Oracle PLSQL- Creating Triggers Compound triggers 3

097 125 Oracle PLSQL- Creating Triggers Compound triggers 4

098 125 Oracle PLSQL- Creating Triggers Compound triggers 5

099 125 Oracle PLSQL- Creating Triggers DDL Triggers

100 125 Oracle PLSQL- Creating Triggers Database Events

101 125 Oracle PLSQL- Creating Triggers Call Statement

102 125 Oracle PLSQL- PLSQL Compiler plsql code type

103 125 Oracle PLSQL- PLSQL Compiler plsql optimize level

104 125 Oracle PLSQL- PLSQL Compiler plsql warnings 1

105 125 Oracle PLSQL- PLSQL Compiler plsql warnings 2

106 125 Oracle PLSQL- PLSQL Compiler dbms warning

107 125 Oracle PLSQL- Managing PLSQL Conditional Complication 1

108 125 Oracle PLSQL- Managing PLSQL Conditional Complication 2

109 125 Oracle PLSQL- Managing PLSQL plsql ccflags 1

110 125 Oracle PLSQL- Managing PLSQL plsql ccflags 2

111 125 Oracle PLSQL- Managing PLSQL plsql ccflags 3

112 125 Oracle PLSQL- Managing PLSQL dbms ddl.create wrapped

113 125 Oracle PLSQL- Managing PLSQL Wrapper Utility 1

114 125 Oracle PLSQL- Managing PLSQL Wrapper Utility 2

115 125 Oracle PLSQL- Managing Dependencies Introduction

116 125 Oracle PLSQL- Managing Dependencies Direct and Indirect

117 125 Oracle PLSQL- Managing Dependencies Nice Practice

118 125 Oracle PLSQL- Managing Dependencies 3 cases

119 125 Oracle PLSQL- Managing Dependencies package case

120 125 Oracle PLSQL- Managing Dependencies Synonym 1

121 125 Oracle PLSQL- Managing Dependencies Synonym 2

122 125 Oracle PLSQL- Managing Dependencies Reduce invalidation

124 125 Oracle PLSQL- Managing Dependencies Remote part 2

125 125 Oracle PLSQL- Thank You