Oracle Database 10g SQL / Edition 1

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 96%)
Other sellers (Paperback)
  • All (14) from $1.99   
  • New (2) from $40.26   
  • Used (12) from $1.99   


Write Powerful SQL Statements and PL/SQL Programs

In this comprehensive book, you’ll learn to write Structured Query Language (SQL) statements to access an Oracle database and use PL/SQL (Procedural Language/SQL) to write programs containing SQL statements. Developed in compliance with the new SQL2003 specification, this definitive resource explains how to use the latest Oracle Database 10g features, and much more. Written by Oracle guru Jason Price, Oracle Database 10g SQL covers everything you need to know to master SQL.

  • Execute queries, inserts, updates, and deletes against a database
  • Write PL/SQL stored programs, packages, and triggers
  • Create database tables, sequences, indexes, views, and users
  • Use SQL*Plus to execute SQL statements, scripts, and reports
  • Perform complex calculations using analytic functions
  • Learn the basics of running SQL using Java through JDBC
  • Use large objects to store up to 128 terabytes of character and binary data
  • Define database object types and create object tables to handle advanced data
  • Use all the latest Oracle Database 10g features such as the BINARY_FLOAT and BINARY_DOUBLE types, the MODEL clause, and more
  • Implement high-performance tuning techniques to make your SQL statements really fly

Covers Oracle Database Releases 8i, 9i, and 10g

Read More Show Less

Product Details

  • ISBN-13: 9780072229813
  • Publisher: McGraw-Hill Professional Publishing
  • Publication date: 2/20/2004
  • Series: Oracle Press Series
  • Edition description: First Edition
  • Edition number: 1
  • Pages: 608
  • Product dimensions: 7.30 (w) x 9.10 (h) x 1.20 (d)

Meet the Author

Jason Price (Castro Valley, CA) has over 10 years experience in the software industry, 5 of which were spent at Oracle. Jason is an Oracle Certified Professional DBA and Application Developer and has written several books:

Java Programming with Oracle SQLJ, O’Reilly (2001)

Oracle9i JDBC Programming, Oracle Press (2002)

Mastering Visual C# .NET, Sybex (2002)

Mastering Visual C# .NET Database Programming, Sybex (2003.

Read More Show Less

Table of Contents

Ch. 1: Introduction Ch. 2: Retrieving Information from TablesCh. 3: Using Simple FunctionsCh. 4: Storing and Processing Dates and TimesCh. 5: Using SQL *Plus Ch. 6: Subqueries Ch. 7: Advanced Select Functions Ch. 8: Changing Table Contents Ch. 9: Database SecurityCh. 10: Creating Database Tables, Indexes, Views, and Sequences Ch 11: Introducing PL/SQL ProgrammingCh. 12: Database ObjectsCh. 13: Collections Ch. 14: Large Objects Ch 15: Native XML SupportCh. 16: Tuning Appendix A Oracle Data Types

Read More Show Less

Customer Reviews

Average Rating 3
( 2 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & 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 & 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 & 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 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


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & 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 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
Sort by: Showing all of 2 Customer Reviews
  • Anonymous

    Posted May 15, 2009

    No text was provided for this review.

  • Anonymous

    Posted May 31, 2010

    No text was provided for this review.

Sort by: Showing all of 2 Customer Reviews

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