Oracle 8 Programming
A Primer
Published on 24. March 2000
Book
Paperback/Softback
334 pages
978-0-201-61258-5 (ISBN)
Description
This concise introduction to Oracle SQL is ideal for students in a database course that requires programming SQL. This book covers the basics of Oracle and includes new topics associated with web server programming. This v.8 edition includes new material on Pro*C++ and a new chapter on SQLJ (a new Java interface to Oracle and other databases). Oracle 8 Object features have also been added, and all of the book's examples are updated to reflect Oracle 8. The final chapter is composed of a number of sample projects and programming applications that implement these basic concepts.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 190 mm
Width: 234 mm
Thickness: 16 mm
Weight
548 gr
ISBN-13
978-0-201-61258-5 (9780201612585)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Previous edition
Book
10/1998
Pearson
€30.94
Article exhausted; check for reprint
Person
Rajshekhar Sunderraman is an assistant professor of mathematics and computer science at Georgia State University in Atlanta. Professor Sunderraman received his Ph.D. in computer science from Iowa State University and has been teaching computer science for more than 10 years. He has published numerous articles on a wide range of topics, including inconsistencies in relational databases, negation in deductive databases, and declarative specification of objects in object-oriented databases.
0201612585AB04062001
0201612585AB04062001
Content
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.
BibTeX Database.
Music Store Database.
Online Auctions Database
Oracle Data Dictionary Browser
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.
BibTeX Database.
Music Store Database.
Online Auctions Database
Oracle Data Dictionary Browser