Friday, January 25, 2019

PL/SQL:

PL/SQL:     


  • Introduction to PL/SQL
  • The Advantage of PL/SQL
  • PL/SQL Block Structure
  • PL/SQL Architecture
  • Fundamentals of PL/SQL
  • PL/SQL Data Types
  • Variables and Constants
  • Scope and Visibility of a Variable
  • Assignments and Expressions
  • Operator Precedence
  • Conditional and Iterative Control
  • Cursor Management in PL/SQL
  • Implicit/explicit Cursor Attributes
  • Exception Handling in PL/SQL
  • Predefined Exceptions
  • User Defined Exceptions
  • Database Trigger
  • types of triggers
  • dropping triggers
  • storage for triggers.

No comments:

Post a Comment