Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

by Jason Price (Author), Jason Price (Author), McGraw-Hill (Author) "The concept of a relational database is not new..." (more)
Key Phrases: src bfile, dob column, phone column values, Tank War, Creative Yell, State Street (more...)

Editorial Reviews

Product Description
This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

From the Back Cover

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

See all Editorial Reviews

Product Details

• Paperback: 608 pages
• Publisher: McGraw-Hill Osborne Media; 1st edition (February 20, 2004)
• Language: English
• ISBN-10: 0072229810
• ISBN-13: 978-0072229813
• Product Dimensions: 9.1 x 7.4 x 1.3 inches
• Shipping Weight: 2.2 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars See all reviews (16 customer reviews)
• Amazon.com Sales Rank: #257,688 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #14 in	Books > Computers & Internet > Databases > Oracle > SQL
  #30 in	Books > Computers & Internet > Databases > Oracle > PL & SQL

Customer Reviews

Most Helpful Customer Reviews

9 of 9 people found the following review helpful:

5.0 out of 5 stars Great coverage of SQL and PL/SQL, June 14, 2004

By	William Barnes - See all my reviews

I liked this book because it covers Oracle 10g SQL as well as PL/SQL, that's great because it saved me buying two separate books!

I was able to download the code from the website and follow along with all the examples with no problem. I especially liked the coverage of the 10g specific features, such as the new MODEL clause and the new 10g database types (BINARY_DOUBLE and BINARY_FLOAT).

All in all, a great book.

8 of 8 people found the following review helpful:

5.0 out of 5 stars Teaches the basics and advanced uses of SQL, May 27, 2004

By	David Billington (Silicon Valley, CA, USA) - See all my reviews

This is a good book. It teaches the basics and advanced uses of SQL. I'd already used SQL and Oracle before, and found the advanced chapters on tuning and the use of large objects and advanced analytical functions.

I downloaded the Zip file from the Oracle Press web site and had the example database up and running in minutes. I didn't have any problems running any of the examples shown in the book.

I also liked the coverage of PL/SQL included in the book. Saved me from buying a book on Oracle 10g PL/SQL. This book even has a chapter on running SQL from within a Java program using JDBC!

6 of 6 people found the following review helpful:

5.0 out of 5 stars Very good book, June 30, 2006

By	Leonard S. "Leonard S." (San Mateo, CA, USA) - See all my reviews

This book is very good. I've had the book for a month now, and use it every day. It is good because it covers both SQL and PL/SQL, as well as all the latest Oracle 10g database features.

I have a number of other Oracle books, and this one is the one I like best. I also liked the reference section which covers all the main Oracle database functions along with real examples. The book is also an easy read.

Hands down the best book on Oracle SQL currently available.