Orient ITM


PL-SQL

  • John Smith

    ·         Introduction to PL/SQL

    PL/SQL Overview

    Benefits of PL/SQL Subprograms

    Overview of the Types of PL/SQL blocks

    Create a Simple Anonymous Block

    Generate Output from a PL/SQL Block

    ·         Standard Functions

    General functions

    Number functions

    Other functions

    ·         PL/SQL Identifiers

    List the different Types of Identifiers in a PL/SQL subprogram

    Usage of the Declarative Section to define Identifiers

    Use variables to store data

    Identify Scalar Data Types

    The %TYPE Attribute

    What are Bind Variables?

    Sequences in PL/SQL Expressions

    ·         Write Executable Statements

    Describe Basic PL/SQL Block Syntax Guidelines

    Comment Code

    Deployment of SQL Functions in PL/SQL

    Converting Data Types

    Nested Blocks

    Identify the Operators in PL/SQL

    ·         Interaction with the Oracle Server

    Invoke SELECT Statements in PL/SQL to Retrieve data

    Dynamic SQL

    Data Manipulation in the Server Using PL/SQL

    SQL Cursor concept

    Usage of SQL Cursor Attributes to Obtain Feedback on DML

    Save and Discard Transactions

    ·         Control Structures

    Conditional processing Using IF Statements

    Conditional processing Using CASE Statements

    Use simple Loop Statement

    Use While Loop Statement

    Use For Loop Statement

    Describe the Continue Statement

    ·         Composite Data Types

    Use PL/SQL Records

    The %ROWTYPE Attribute

    Insert and Update with PL/SQL Records

    Associative Arrays (INDEX BY Tables)

    Examine INDEX BY Table Methods

    Use INDEX BY Table of Records

    ·         Explicit Cursors



Korporativ müştərilərimiz