I'm a student
I'm an educator
Request full copy

Oracle 10g Programming: A Primer, 1st edition

Published by Pearson (May 9, 2007) © 2008

  • Rajshekhar Sunderraman Georgia State University
$79.99

  • Hardcover, paperback or looseleaf edition
  • Affordable rental option for select titles
  • Free shipping on looseleafs and traditional textbooks
Oracle 10G Programming is a concise, streamlined guide to Oracle programming. It is ideal for students studying databases, and introduces the Oracle technology students need to know for a first database course.
This easily accessible primer is divided into two sections for ease of use. The first part of this book offers a basic review of the relational model and an introduction to Oracle SQL and PL/SQL. The second part introduces related technologies that facilitate Oracle Web functionality. There are chapters on SQLJ, Oracle Web programming with 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.
  • Includes concise coverage of basic Oracle SQL programming and Web connectivity.
  • Covers advanced topics such as SQLJ, PL/SQL, JDBC, PSP, Java Servlets, and Oracle XML.
  • Three continuous sample databases—grade book, mail order, and portfolio databases—are introduced early in the book and used throughout the text to illustrate key concepts.
  • Suggested database projects readers can use to practice covered concepts are presented in the final chapter.
  • End-of-chapter exercises ask students to apply the concepts of the chapter to the three running database examples.
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.
Rajshenkhar Sunderraman is an associate professor of computer science at Georgia State University in Atlanta, Georgia. Professor Sunderraman received his PhD in computer science from Iowa State University. He has published numerous articles on a wide range of topics, including deductive databases and logic programming; incompleteness, inconsistency, and negation in databases; deductive and object-oriented databases; Web access to databases; and semi-structured data on the Web.

Need help? Get in touch

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable by deleting your cookies.

Video transcript (PDF | 16KB) 

Pearson eTextbook: What’s on the inside just might surprise you

They say you can’t judge a book by its cover. It’s the same with your students. Meet each one right where they are with an engaging, interactive, personalized learning experience that goes beyond the textbook to fit any schedule, any budget, and any lifestyle. 

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars