Attention! - Oracle® Authorized Test Center. Write Any Exam at Any Time (24 Hours/365 Days) in lowest price. (Free Exam Materials for Oracle Exams)


Pl/SQL Training in Chennai SQLSTAR Global Syllabus

Pl/SQL Fundamentals [24 Hours]

  • Introduction to PL/SQL
  • Declaring PL/SQL Variables
  • Writing Executable Statements
  • Using SQL Statements within a PL/SQL Block
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating subprograms
  • Develop PL/SQL Program Units [24 Hours]
  • Creating Stored Procedures
  • Creating Functions and Debugging Subprograms
  • Creating Packages
  • Working With Packages
  • Using Oracle-Supplied Packages in Application Development
  • Using Dynamic SQL
  • Design Considerations for PL/SQL Code
  • Creating Triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Using PL/SQL compiler
  • Managing Dependencies

  • AWS Training Data Science Training in ISQL Global Big Data Training in ISQL Global

    All rights reserved. ©1999 - 2020, SQLSTAR Global.