Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

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

Overview

To identify the steps for getting started with PL/SQL, recognizing the benefits of the available tools, creating basic statements, declaring variables, testing code, and adhering to scoping and nesting rules.

Target Audience

Application developers, database designers, database administrators, forms developers, PL/SQL developers, and technical consultants

Prerequisites

The learner should have experience and knowledge with SQL, specifically the Oracle Database 11g: SQL Fundamentals I and Oracle Database 11g: SQL Fundamentals II learning paths.

Expected Duration

115 min.

Course Objectives

Oracle Database 11g: PL/SQL Variables, Attributes, and Executable Statements

  • recognize the features and capabilities of SQL Developer, SQL*Plus, and JDeveloper.
  • identify the features and benefits of PL/SQL and identify the steps for building basic PL/SQL blocks.
  • identify the steps for declaring and initializing PL/SQL variables.
  • identify the uses of different PL/SQL data types, the %TYPE attribute, and BIND variables.
  • identify the steps for constructing executable statements using various PL/SQL block elements.
  • evaluate a block of PL/SQL code with respect to scoping and nesting rules, and write and test PL/SQL blocks.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?