Oracle Programming
A Primer, Version 7.0
Published on 20. October 1998
Book
Paperback/Softback
336 pages
978-0-201-35753-0 (ISBN)
Description
This concise introduction to Oracle SQL is ideal for students in a database course that requires programming SQL or professionals interested in getting up and running on using the most prevalent database management systems. This book covers the basics of Oracle and includes newer topics associated with web server programming. 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: 234 mm
Width: 189 mm
Thickness: 14 mm
Weight
475 gr
ISBN-13
978-0-201-35753-0 (9780201357530)
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
New editions
Book
03/2000
Pearson
€29.70
Article is exhausted; no 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.
0201357534AB04062001
0201357534AB04062001
Content
1. The Relational Model 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.
3. Embedded SQL Host Variables.
Indicator Variables.
SQL Communications Area.
Connecting to Oracle.
Cursors.
Mail Order Database Application.
Recursive Queries.
Error handling.
Transaction Control.
Dynamic SQL.
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.
5. Oracle JDBC What is JDBC.
A Simple Exercise.
Developing JDBC Applications.
Non-Query SQL Statements.
Executing SQL Queries.
A Complete Example.
Database Metadata.
Errors and Warnings.
6. Projects Airline Flight Information Systems.
Library Database Application.
University Student Database.
Video Chain Database.
Banking Database.
BibTeX Database.
Music Store Database. 0201357534T04062001
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.
3. Embedded SQL Host Variables.
Indicator Variables.
SQL Communications Area.
Connecting to Oracle.
Cursors.
Mail Order Database Application.
Recursive Queries.
Error handling.
Transaction Control.
Dynamic SQL.
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.
5. Oracle JDBC What is JDBC.
A Simple Exercise.
Developing JDBC Applications.
Non-Query SQL Statements.
Executing SQL Queries.
A Complete Example.
Database Metadata.
Errors and Warnings.
6. Projects Airline Flight Information Systems.
Library Database Application.
University Student Database.
Video Chain Database.
Banking Database.
BibTeX Database.
Music Store Database. 0201357534T04062001