Course Outline

Introduction to PL/SQL

    Runtime Structure and types of blocks PL/SQL Declaring and using variables Decision making, loops

Commands SQL in PL/SQL

    DML commands DDL commands and dynamic SQL TCL commands and transactionality SELECT command

Procedures and functions

    Creating and deleting Parameterization

Handling errors and exceptions

Creating and using cursors

    Records Static cursors Parameterizing cursors

Triggers

    DML triggers View triggers (INSTEAD OF) System triggers

Requirements

Basic programming skills in any structured or object-oriented language. Familiar use of the basics of the language SQL and knowledge of the Oracle database environment

 14 Hours

Number of participants



Price per participant

Testimonials (12)

Related Courses

Related Categories