Oracle 10g Programming A Primer

Name: Oracle 10g Programming A Primer
Availability: InStock
ISBN: 9780321463043

ISBN-10: 0321463048

ISBN-13: 9780321463043

Edition: 2nd 2008 (Revised)

Authors: Rajshekhar Sunderraman

List price: $93.32

This item qualifies for FREE shipping.

30 day, 100% satisfaction guarantee!

Semester Rental: $19.09 Due date: 8/14/2024

Rental notice: supplementary materials (access codes, CDs, etc.) are not guaranteed with rental orders.

Buy used: $7.12

Buy new: $86.09

Marketplace

3 new & used from $7.01

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

KEY MESSAGE: Oracle 10G Programming is a concise, streamlined guide to Oracle SQL. It is ideal for readers learning about databases, and introduces the Oracle concepts readers need to know for a first experience with databases. 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.

Book details

List price: $93.32
Edition: 2nd
Copyright year: 2008
Publisher: Pearson Education
Publication date: 5/9/2007
Binding: Paperback
Pages: 552
Size: 7.30" wide x 9.00" long x 1.20" tall
Weight: 1.738
Language: English




The Relational Data Model


The Relational Database


Integrity Constraints


Tabular View of a Relation


Sample Databases


Relational Algebra



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



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



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



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



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



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



Oracle XML


Basic Syntax


Document Type Definitions (DTDs)


XML Parsing in Java


Oracle XML-SQL Utility (XSU)


XMLType


Exercises



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