Home
Oracle PL / SQL
Aggregate Functions
Analytical Functions
Char Functions
Constraints
Conversion Functions
Cursor
Data Type
Date Timezone
Hierarchical Query
Index
Insert Delete Update
Large Objects
Numeric Math Functions
Object Oriented Database
PL SQL
Regular Expressions
Report Column Page
Result Set
Select Query
Sequence
SQL Plus
Stored Procedure Function
Subquery
System Packages
System Tables Views
Table
Table Joins
Trigger
User Previliege
View
XML
Variable Scope « PL SQL « Oracle PL / SQL
Oracle PL / SQL
PL SQL
Variable Scope
1.
Variable scope in variable 'declare' block
2.
Illustrates the scope of various identifiers
3.
Variable scope in a PL/SQL
4.
Identifiers defined in the declaration of the child block are only in scope and visible within the child block itself.
5.
if you try to reference a variable before you declare it because PL/SQL requires an identifier be declared before we use it in our code
6.
This type is local to this block
7.
Reference Type in another block as well
8.
variable scope with nested block
9.
Override your scope access to containing blocks by reusing an identifier in a nested block