PL/SQL User's guide and reference version 2.0 Oracle/

Publication details: Redwood City Oracle cooperative server 1992Description: xviii; (various paging) ill; 23 cmSubject(s): DDC classification:
  • 22 005.13  SQL
Tags from this library: No tags from this library for this title. Log in to add tags.
Star ratings
    Average rating: 0.0 (0 votes)

Table of Content

PART USER'S GUIDE
CHAPTER 1 Overview
Main Features
Block Structure
Variables and Constants
Attributes
Control Structures
Architecture
Advantages of PL/SQL

Chapter 2 Fundamentals of PL/SQL
Character Set
Lexical Units
Datatypes
Datatype conversion
Declarations
Etc.

Chapter 3 PL/Control structures
Conditional control: IF statements
Iterative control: LOOP and EXIT
sequential control : GOTO and NULL exit statements


4 Interaction with ORACLE
SQL support
National language support
Remote access
Cursor management
Transaction processing
Etc.

Chapter 6 Subprograms
What are subprograms
Advantages of subprograms
Procedures
Functions
RETURN statement
Etc.

Chapter 7 Packages
What is a package
Advantages of packages
The package specification
The package body
Private versus public objects
Etc.

Chapter 8 Execution Environments
SQL Plus environment
Oracle Precompiler environment
OCI environment

PART II LANGUAGE REFERENCE
Chapter 9 Language elements
Using syntax diagrams
Assignment statement
Blocks
CLOSE statement
Comments
Etc.










Includes Index: various paging

There are no comments on this title.

to post a comment.