Oracle Training

Oracle Training

In Oracle Training In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.

Understand the PL/SQL Development Environment. Learn the basics of the PL/SQL language, declare and work with variables, use conditionals and loops in PL/SQL, handle and create user-defined exceptions, use SQL within PL/SQL, Learn about nested blocks and variable scope, create Subprograms, Stored Procedures and Functions, work with Packages, Triggers and Cursors and use Oracle Supplied Packages

Oracle Supplied Packages

DBMS_URL: Working with URLS - Identifying Package Subprograms - Dynamic SQL

Environment for PL/SQL Development

Prerequisites - Executing PL/SQL Code, SQL Developer Configuration,PL/SQL Development Cycle

PL/SQL Basics

Executing PL/SQL Blocks and Functions - Named Block Structure - Executing Blocks

Declaring Variables

Variable Declaration, Initialization and Display - Complex Variable Types

Within the Block

Conditional Processing - Iterative Processing - Salary Increases using loops.

Use of SQL in PL/SQL

Implicit Cursors - %TYPE and %ROWTYPE Attributes - EXECUTE IMMEDIATE statement - Cursors Attributes

Related Courses