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.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 190 mm
Breite: 234 mm
Dicke: 16 mm
Gewicht
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 Klassifikation
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
