Preface
Introduction
List of Programs
What You Will Need
Programming Conventions
The C Programming Language
C Environment
Main Dialog
Game Strategy
Graphics
Game Support Routines
Text Box 1 - Tic Tac Toe Strategy
Text Box 2 - Computerized Tic Tac Toe
What is SQL
Essential SQL Statements
Sample Database
Creating a Table
Describing the Structure of a Table
Inserting Data into a Database Table
Selecting Data from a Database Table
Updating Existing Data in a Database Table
Deleting Data from a Database Table
Advanced SQL Queries
Functions
Groups and Counts
Joins
Sub-Queries
Other Advanced SQL Statements
Indexes
Grants
Components of Oracle
Oracle Hardware Platforms
SQL*Plus
Editing the SQL Buffer
SQL*Plus Command Files
SQL*Forms
Starting SQL*Forms Designer
Choosing the Form and Block
Painting the Form
Specifying Block Options
Generating the Executable Form
Using Your Completed form
SQL*Forms Triggers
Reports
A Simple Report Using SQL*Plus
Oracle RDBMS
The Oracle Database
The Oracle RDBMS Processes
How the Oracle RDBMS Processes an SQL Statement
PL/SQL
What is Embedded SQL
Host Variables
The SQLCA
The INTO Clause
Oracle Pro*C
Creating a Pro*C Program
Precompiling Your Pro*C Program
Compiling Your Pro*C Program
Linking Your Pro*C Program
Running Your Pro*C Program
Pro*C Environment
Main Dialog
Game Strategy
Graphics
Game Support Routines
Database Support Routines
Text Box 3 - Alternate Versions of Tic Tac Toe
Text Box 4 - Machine Learning
Text Box 5 - Fractals
What is the Client Server Model
Details on Client-Server
Other Architectures
Oracle Corporation Approaches and Products
What is SQL*Net
SQL*Net Protocols
SQL*Net for Banyan VINES
Using SQL*Net
Other Vendors Approaches and Products
Microsoft's Approach
IBM's Systems Application Architecture (SAA)
SQL as a Communications Protocol
Dynamic SQL
Oracle's SQLDA
IBM's DB2 SQLDA
Descriptors
Description of SQLSRVR Program
Stored Procedures
Multi-statement Transactions
Server Triggers and Constraints
SQLSRVR Program Listing
Introduction to Data Communications
Terminal Emulation
Transferring Files
Distributed Processing
ASCII Encoding
RS232
Error Detection and Correction
Flow Control
What is a Network
Wide Area Networks
Local Area Networks
Open Systems Interconnection (OSI) 7 Layer Model
Application Layer
Presentation Layer
Session Layer
Transport Layer
Network Layer
Data Link Layer
Physical Layer
Application Layer
LAYER_7 Program Listing
Transport Layer
LAYER_4 Program Listing
Data Link Layer
LAYER_2 Program Listing
LAYR2_PC Program Listing
LAYR2_VX Program Listing
Physical Layer
Queue and Buffer Handling
Q_BUFF Program Listing
Description of SQLPCC Program
SQLPCC Program Listing
Installing the Distributed Application
Creating the Client Executable
PC Configuration Files
PROCOMM PLUS
Crosstalk
Other PC Communications Packages
VAX
Kermit
Oracle on a VAX
VAX C Compiler
VAX Linker with Oracle
Running SQL Server
Data General
MS-DOS PCs as Servers
Using the Distributed Application
Starting Up
Client-Server Interaction
Closing Down
Generic SQL Windows
Customized SQL Windows
meTTTa Definitions & Declarations
C Header Files
sqlsrvr.h
fproto.h
q_buff.h
sql_comm.h