Using PL/SQL with an Oracle Server

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

Overview

To write lexical units in their correct format in a PL/SQL block, perform data conversion in PL/SQL, write PL/SQL anonymous blocks, and recognize the correct structure of a PL/SQL program block

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

120 min.

Course Objectives

Using PL/SQL with an Oracle Server

  • write lexical units in their correct format in a PL/SQL block.
  • perform data conversion in PL/SQL.
  • use qualifiers to access and evaluate variables in PL/SQL blocks.
  • convert and evaluate variables in PL/SQL.
  • use a SELECT statement in a PL/SQL block to retrieve data from a database.
  • use implicit SQL cursor attributes to determine the outcome of DML commands.
  • use PL/SQL to perform database operations and use SQL cursor attributes to evaluate results.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?