Oracle Database 11g Program with PL/SQL 2.0 Training Institute in Chennai SQL STAR
- 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 [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