QUICK ENQUIRY
 


 Course Content of PL/SQL

Oracle Database: Introduction to PL/SQL                                               Home

Course Topics

  • Introduction to PL/SQL

  • Declare PL/SQL Identifiers

  • Write Executable Statements

  • Interaction with the Oracle Server

  • Control Structures

  • Composite Data Types

  • Explicit Cursors

  • Exception Handling

  • Stored Procedures

  • Stored Functions and Debugging Subprograms

  • Packages

  • Deploying Packages

  • Implement Oracle-Supplied Packages in Application Development

  • Dynamic SQL

  • Design Considerations for PL/SQL Code

  • Triggers

  • Creating Compound, DDL, and Event Database Triggers

  • PL/SQL Compiler

  • Manage PL/SQL Code

  • Manage Dependencies