Oracle 10G Programming: A Primer / Edition 2

Paperback (Print)
Rent
Rent from BN.com
$22.63
(Save 64%)
Est. Return Date: 09/20/2014
Buy New
Buy New from BN.com
$52.84
Buy Used
Buy Used from BN.com
$42.78
(Save 31%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $24.50
Usually ships in 1-2 business days
(Save 60%)
Other sellers (Paperback)
  • All (13) from $24.50   
  • New (6) from $46.50   
  • Used (7) from $24.50   

Overview

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.

The Relational Data Model, Oracle SQL, PL/SQL, Web Programming with PL/SQL, Oracle JDBC, SQLJ: Embedded SQL in Java, Oracle Web Programming with Java Servlets, Oracle XML, Projects.

MESSAGE: For all readers interested in Oracle 10G.

Read More Show Less

Product Details

  • ISBN-13: 9780321463043
  • Publisher: Addison-Wesley
  • Publication date: 2/15/2007
  • Edition description: REV
  • Edition number: 2
  • Pages: 300
  • Sales rank: 502,815
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.10 (d)

Meet the Author

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.
Read More Show Less

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.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)