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

Jason Price (Author), McGraw-Hill (Author)

Book Description

ISBN-10: 0072229810 | ISBN-13: 978-0072229813 | Publication Date: February 20, 2004 | Edition: 1st

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.

Editorial Reviews

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

About 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.

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 (17 customer reviews)
• Amazon Best Sellers Rank: #264,761 in Books (See Top 100 in Books)
  • #22 in Books > Computers & Technology > Databases > Oracle
  • #45 in Books > Computers & Technology > Databases > Relational Databases

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

10 of 10 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

This review is from: Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

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.

9 of 9 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 review is from: Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

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!

7 of 7 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 review is from: Oracle Database 10g SQL (Osborne ORACLE Press Series) (Paperback)

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.