Training Syllabus
NCORC011 - Oracle 11g Introduction To PL SQL

Durasi : 5 hari

  • Introduction to PL/SQL
  • Declaring PL/SQL Identifiers
  • Writing Executable Statements
  • Interacting with the Oracle Server
  • Writing Control Structures
  • Working with Composite Data Types
  • Using Explicit Cursors
  • Handling Exceptions
  • Creating Stored Procedures
  • Creating Stored Functions
  • 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 the PL/SQL Compiler
  • Managing PL/SQL Code
  • Managing Dependencies