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
Item type | Current library | Call number | Copy number | Status | Date due | Barcode |
---|---|---|---|---|---|---|
Book Open Access | Engineering Library | 005.13 SQL 1 (Browse shelf(Opens below)) | 1 | Available | BUML23101042 |
Browsing Engineering Library shelves Close shelf browser (Hides shelf browser)
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.