|
Fundamentals of PL/SQL
· Lexical Units
· Data Types
· Data Type Conversion
· Explicit Conversion
· Implicit Conversion
· Date
· Declarations
· Default value
· NOT NULL
· Forward Reference
· Aggregate Assignment
· Using Aliases
· Naming Conventions
· Scoping
· Case Sensitivity
· Name Resolution
· Assignment
· Database Value
· Expressions and Comparisons
· Logical Operators
· Order of Evaluation
· Built-in Functions in PL/SQL
Control Structures
· Conditional Control Statements
· Guidelines For Using IF Statements
· Iterative Statements
· FOR LOOP
· Scope Of Counter Variable
· EXIT Statement
· WHILE LOOP
· LOOP.... EXIT Statement
· GOTO Statements
· NULL Statement
Interaction with
Oracle
· SELECT ... INTO Statement
· Cursor
· Declaration
· Opening A cursor
· Closing A cursor
· Using Cursor FOR Loops
· Substituting Sub Queries In Place Of Cursor
· Using Aliases For Fields
· Cursor Attributes
· Examples Related With Cursor
· Implicit Cursor Attributes
· Cursor Variables
· Opening Cursor
· Opening A Cursor Variable In Stored Procedure
· Fetching Data From Cursor
· Closing Cursor
· Reducing Network Traffic By Using
Cursor Variables
· Exception In Case Of Cursor
· Exceptions Due To Aliasing
· Use of Cursor In Package
Transaction control
statements
· Rollback
· Save Point
· Implicit Save Point
· Ending Of Transactions
· Fetching Across Commit
Error Handling
· Exceptions
· Utility of Exceptions
· Built-in Exceptions
· User-defined Exceptions
Subprograms
· Procedures
· Functions
· Parameters
· Methods of Passing Actual Parameters
. Mode of Passing Parameters
|
