Oracle 8 Programming

A Primer

Rajshekhar Sunderraman (Autor)

Buch | Softcover

334 Seiten

2000
Pearson (Verlag)
978-0-201-61258-5 (ISBN)

Titel ist leider vergriffen;
keine Neuauflage

Artikel merken

This work covers the basics of Oracle and includes topics associated with web server programming. The v.8 edition features new material on Pro*C++ and a new chapter on SQL.

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.

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

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

Erscheint lt. Verlag	24.3.2000
Sprache	englisch
Maße	234 x 190 mm
Gewicht	548 g
Themenwelt	Informatik ► Datenbanken ► Oracle
Themenwelt	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	0-201-61258-5 / 0201612585
ISBN-13	978-0-201-61258-5 / 9780201612585
Zustand	Neuware