Your textbook…
Cover image for Oracle 9i Programming: A Primer
View larger cover

Oracle 9i Programming: A Primer

By Rajshekhar Sunderraman

ISBN-10: 0-321-19498-5

ISBN-13: 978-0-321-19498-5What's this?

Published by Addison-Wesley

© 2004

Pub. Date: May 23, 2003

Format: Paper

Table of Contents



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.

This textbook is also sold in the various packages listed below. Before purchasing one of these packages, speak with your professor about which one will help you be successful in your course.

Package ISBN-13: 9780321281821

$155.00 | Add to Cart

This package contains:

  • Oracle 9i Programming: A Primer
    Rajshekhar Sunderraman | ©2004 | Paper; 334 pages
  • Database Systems: An Application-Oriented Approach, Introductory Version, 2nd Edition
    Michael Kifer, Arthur Bernstein, Philip M. Lewis | ©2005 | Paper; 688 pages

Package ISBN-13: 9780321206725

$194.00 | Add to Cart

This package contains:

  • Oracle 9i Programming: A Primer
    Rajshekhar Sunderraman | ©2004 | Paper; 334 pages
  • Introduction to Database Systems, An, 8th Edition
    C.J. Date | ©2004 | Paper; 1024 pages

Package ISBN-13: 9780321206770

$136.67 | Add to Cart

This package contains:

  • Oracle 9i Programming: A Primer
    Rajshekhar Sunderraman | ©2004 | Paper; 334 pages
  • Principles of Database Systems with Internet and Java Applications
    Greg Riccardi | ©2001 | Cloth Package

Package ISBN-13: 9780321504234

$175.00 | Add to Cart

This package contains:

  • Oracle 9i Programming: A Primer
    Rajshekhar Sunderraman | ©2004 | Paper; 334 pages
  • Fundamentals of Database Systems, 5th Edition
    Ramez Elmasri, Shamkant B. Navathe | ©2007 | Cloth; 1168 pages
  • Database Place Student Access Kit
    Addison-Wesley | ©2006 | Paper Bound with PIN

Textbook

List Price: $50.00

Add to Shopping Cart

Members pay only $45.00

Free FedEx Ground Shipping.