PL/SQL ONLINE TRAINING

PL-SQL Course Content

    Overview of the PL-Sql

• Introduction to Pl/Sql
• About Blocks
• Variables in Pl/Sql
• Record Types
• Conditional Programming
• Control Statements
• Connecting to Oracle
• SQL*Developer
• Executing PL/SQL Code
• SQL Developer Configuration
• Executing Blocks
• Calling PL/SQL Functions
• Executing PL/SQL Blocks and Functions
• Declaring Variables
• Variable Usage
• Variable Data Types
• Variable Naming
• Variable Assignment
• Variable Display
• Cursors as Parameters
• Subprogram Development Techniques
• Addressing Compilation Errors
• Directives for Debugging
• Issues with Booleans
• Integrated Development Environments
• PL/SQL Subprograms with Parameters

    Using the Rich Controls

• Stored Procedures
• Functions
• Packages
• Triggers
• Pragmas
• Pl/Sql Tables
• Nested Tables
• Varray
• Forward declarations
• Ref cursors
• Dynamic Sql