Oracle 9i Programming
A Primer
Published on 3. July 2003
Book
Paperback/Softback
334 pages
978-0-321-19498-5 (ISBN)
Description
Oracle 9i Programming is a concise, streamlined introduction to Oracle SQL. It is ideal for students and professionals learning about databases.
The first part of this book offers a basic review of the relational model, then moves on to an introduction to Oracle SQL and PL/SQL. The second part introduces related technologies that facilitate Oracle Web functionality. There are chapters on SQLJ, Java Servlets and Oracle XML. The final chapter of this book is composed of a number of sample projects and programming applications that implement the basic concepts covered in this brief primer. All of the book's examples are updated to reflect Oracle 9i.
The first part of this book offers a basic review of the relational model, then moves on to an introduction to Oracle SQL and PL/SQL. The second part introduces related technologies that facilitate Oracle Web functionality. There are chapters on SQLJ, Java Servlets and Oracle XML. The final chapter of this book is composed of a number of sample projects and programming applications that implement the basic concepts covered in this brief primer. All of the book's examples are updated to reflect Oracle 9i.
More details
Language
English
Place of publication
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 186 mm
Width: 236 mm
Thickness: 17 mm
Weight
683 gr
ISBN-13
978-0-321-19498-5 (9780321194985)
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
Content
1. The Relational Data 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.
Oracle9i Object Features.
Exercises.
3. PL/SQL.
What is PL/SQL?
Data Types 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 Oracle9i Objects.
Exercises.
4. Web Programming with PL/SQL.
HTTP.
A Simple Example.
Printing HTML Tables.
Passing Parameters.
Processing HTML Forms.
Multi-Valued Parameters.
PL/SQL Web Toolkit.
PL/SQL Server Pages (PSP).
Exercises.
5. Oracle JDBC.
What is JDBC?
A Simple Example.
Developing JDBC Applications.
Non-Query SQL Statements.
Executing SQL Queries.
Grade Book Application.
Database Metadata.
Errors and Warnings.
Scrollable ResultSets.
Exercises.
6. SQLJ: Embedded SQL in Java.
What is SQLJ?
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.
Exercises.
7. Oracle Web Programming with Java Servlets.
A Simple Servlet.
HTTP Servlet API Basics.
Web Shopping Application.
HTML Form Processing in Servlets.
Search Parts and Add to Cart.
Oracle's Dynamic HTML Generation Package.
Java Server Pages.
Exercises.
8. Oracle XML.
Basic Syntax.
Document Type Definitions (DTDs).
XML Parsing in Java.
Oracle XML-SQL Utility (XSU).
XMLType.
Exercises.
9. Projects.
Airline Flight Information System.
Library Database Application.
University Student Database.
Video Chain Database.
Banking Database.
BiBTeX Database.
Music Store Database.
Online Auctions Database.
Oracle Data Dictionary Browser.
Oracle Data Browser on the Web.
QBE Interface on the Web.
A Web Survey Management System.
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.
Oracle9i Object Features.
Exercises.
3. PL/SQL.
What is PL/SQL?
Data Types 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 Oracle9i Objects.
Exercises.
4. Web Programming with PL/SQL.
HTTP.
A Simple Example.
Printing HTML Tables.
Passing Parameters.
Processing HTML Forms.
Multi-Valued Parameters.
PL/SQL Web Toolkit.
PL/SQL Server Pages (PSP).
Exercises.
5. Oracle JDBC.
What is JDBC?
A Simple Example.
Developing JDBC Applications.
Non-Query SQL Statements.
Executing SQL Queries.
Grade Book Application.
Database Metadata.
Errors and Warnings.
Scrollable ResultSets.
Exercises.
6. SQLJ: Embedded SQL in Java.
What is SQLJ?
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.
Exercises.
7. Oracle Web Programming with Java Servlets.
A Simple Servlet.
HTTP Servlet API Basics.
Web Shopping Application.
HTML Form Processing in Servlets.
Search Parts and Add to Cart.
Oracle's Dynamic HTML Generation Package.
Java Server Pages.
Exercises.
8. Oracle XML.
Basic Syntax.
Document Type Definitions (DTDs).
XML Parsing in Java.
Oracle XML-SQL Utility (XSU).
XMLType.
Exercises.
9. Projects.
Airline Flight Information System.
Library Database Application.
University Student Database.
Video Chain Database.
Banking Database.
BiBTeX Database.
Music Store Database.
Online Auctions Database.
Oracle Data Dictionary Browser.
Oracle Data Browser on the Web.
QBE Interface on the Web.
A Web Survey Management System.