ORACLE PL/SQL 

 

We are currently offering Oracle Developer traininig program that covers from basic to advance level learning.

 

Course Outline

 

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