Oracle Programming
Pearson (Verlag)
978-0-201-35753-0 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
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.
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
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
| Erscheint lt. Verlag | 20.10.1998 |
|---|---|
| Sprache | englisch |
| Maße | 189 x 234 mm |
| Gewicht | 475 g |
| Themenwelt | Informatik ► Datenbanken ► Oracle |
| Mathematik / Informatik ► Informatik ► Software Entwicklung | |
| ISBN-10 | 0-201-35753-4 / 0201357534 |
| ISBN-13 | 978-0-201-35753-0 / 9780201357530 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
aus dem Bereich
