Introduction to PL/SQL

This course is included in our On-demand training solution.

Overview

To introduce PL/SQL and provide an introduction to identifiers and variables in PL/SQL

Target Audience

Database administrators, application developers, and database operators

Prerequisites

Familiarity with Oracle Database 10g database technology; an understanding of the basic concepts of relational databases and the SQL programming language; ability to write queries against single and multiple tables, manipulate data in tables, create database objects, and query metadata

Expected Duration

135 min.

Course Objectives

Introduction to PL/SQL

  • recognize the correct structure of a PL/SQL program block.
  • use iSQL*Plus to display the output of a PL/SQL anonymous block.
  • declare and initialize a variable in a given scenario.
  • declare and initialize scalar data types and Boolean variables.
  • declare and initialize scalar types.
  • use bind and substitution variables and the DEFINE command to assign values in PL/SQL code.
  • match the composite and LOB data types with their associated functionality.
  • pass runtime values in and out of PL/SQL code.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?