Oracle 8 Programming: A Primer / Edition 1

Oracle 8 Programming: A Primer / Edition 1

by Rajshekhar Sunderraman
     
 

ISBN-10: 0201612585

ISBN-13: 9780201612585

Pub. Date: 12/16/1999

Publisher: Pearson Education

This programming companion from Rajshekhar Sunderraman is a streamlined approach to Oracle SQL, the most prevalent database language in industry and on campus. Focusing entirely on the necessary aspects of Oracle, it is designed as a specific guide for new users of this application. Using this primer in the classroom, students will be able to complete programming…  See more details below

Overview

This programming companion from Rajshekhar Sunderraman is a streamlined approach to Oracle SQL, the most prevalent database language in industry and on campus. Focusing entirely on the necessary aspects of Oracle, it is designed as a specific guide for new users of this application. Using this primer in the classroom, students will be able to complete programming projects and assignments that use Oracle. These projects can be developed in a number of different programming environments (PRO*C, PL/SQL, and Oracle JDBC), thereby giving instructors flexibility and choice in these assignments.

Product Details

ISBN-13:
9780201612585
Publisher:
Pearson Education
Publication date:
12/16/1999
Edition description:
New Edition
Pages:
334
Product dimensions:
7.52(w) x 9.20(h) x 0.64(d)

Related Subjects

Table of Contents

1. The Relational Model.
The Relational Database
Integrity Constraints.
Tabular View of a Relation.
Sample Databases:
Relational Algebra

2. Oracle SQL.
Oracle SQL Plus.
Creating, Dropping, and Altering Tables.
Inserting Rows.
Querying the Database.
Views.
Modifying the Database.
Sequences.
Oracle Data Dictionary.
Oracle8 Object Features

3. Embedded SQL (Pro*C/Pro*C++).
Host Variables.
Indicator Variables.
SQL Communications Area (sqlca)
Connecting to Oracle.
Cursors.
Recursive Queries.
Error Handling.
Transaction Control.
Dynamic SQL.
Pro*C++.

4. PL/SQL.
What is PL/SQL?
Datatypes and Variables.
Program Control Statements.
Program Structure.
Triggers.
Database Access Using Cursors.
Records.
PL/SQL Tables.
Built-In Packages.
Error Handling.
PL/SQL Access to Oracle8 Objects

5. Oracle JDBC.
What is JDBC?
A Simple JDBC Program
Developing JDBC Applications.
Non-Query SQL Statements.
Executing SQL Queries.
Grade Book Application.
Database Metadata.
Errors and Warnings.

6. SQLJ: Embedded SQL in Java
What is SQLJ?
A Simple Example.
Compiling SQLJ Programs
Multiple Connections
Host Variables and Expressions
SQLJ Iterators
Dynamic SQL Using JDBC
Calling PL/SQL from Within SQLJ
Investment Portfolio Database Application

7. Projects.
Airline Flight Information Systems.
Library Database Application.
University Student Database.
Video Chain Database.
Banking Database.
BibTeXDatabase.
Music Store Database.
Online Auctions Database
Oracle Data Dictionary Browser

Read More

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >