Oracle SQL: The Essential Reference

by David C. Kreines

Book Overview

SQL (Structured Query Language) is the heart of a relational database management system. It's the language used to query the database, to create new tables in the database, to update and delete... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1565926978
• ISBN13: 9781565926974
• Release Date: September 2000
• Publisher: O'Reilly Media
• Length: 415 Pages
• Weight: 0.10 lbs.
• Dimensions: 0.8" x 7.0" x 9.1"

Customer Reviews

Pretty good reference, with some minor issues

likes: pretty complete on sql statements and functions dislikes: why organize it into "data definition" and "data manipulation" sections? Why not just put all the statements in one alphabetically organized section? missing section on operator precedence (at least, accding to the index. maybe it's in there somewhere)

It's a SQL REFERENCE, dummy!

I have found this book to be an invaluable reference to SQL, PL/SQL, and SQL*Plus syntax and usage. The previous review by Kevin McCormick seems to entirely miss the point of an Essential Reference - it is not intended to teach SQL concepts, and the introduction clearly states this. The book is well organized with exactly the information needed to write a particular statement. The examples are simple and to the point - I don't need a complex example; just something to show me what the statement should look like (for example, to show me that an argument should be a string and not a number). I bought two copies: one for the office and one for home. The book is as close to indispensible as you can get. I only hope the author is planning an update to Oracle 9!

You can't live without this book

Well maybe you could live without this book if you had food and water, but you wouldn't be happy about it. SQL isn't especially difficult, but it's hard to remember all of the syntax. Then couple this with the differences between Oracle's SQL and other database's versions and you have a serious headache that will not go away.As in almost all O'Reilly books, this one is very well-organized and easy to follow. There are just enough examples to get you by, though if you are coupling Oracle, SQL and a scripting language like ColdFusion you might get confused with the "command line only" examples. Oracle's Technet reference online is also good for this information, but they have a tendency to move URLs when you least expect it. This book is relatively inexpensive, and when kept within arm's reach you can whip out SQL queries in nothing flat. Earmark the reserved words section and remember where the Aggregate Functions section starts and you should be good.The first half of the text is really enough to recommend the purchase, but this book also goes over SQL*Plus and PL/SQL, as well as some brief tips on SQL statement tuning. It isn't enough to be complete, but it's more than enough to get you started.This is an indispensible book!

Excellent reference

I agree with the previous reviewer that this book is not a tutorial. But it is an outstanding reference that will save you many long, frustrating and tedious hours of pouring through the Oracle documentation looking for the syntax of various Oracle commands. I've been spending the last few months developing a JDBC based application and this is the only book that I carry with me between work and home. If you've ever been kept up late trying to get the syntax right on some complex SELECT or CREATE TABLE command, this is the book for you.

Oracle SQL: The Essential Refernce

This book is exactly what it says it is. It is a solid (in comparison to other reference books that I have used) reference guide to ORACLE's implementation of the SQL language. If you are looking for a tutorial on SQL, then this is probably not the book that you want to buy. This is a good book if you are a developer whom needs a quick reference guide. The beginning section of the reference chapter is, in my opinion, a little bit of a kluge. The authors attempt to list everything that a DBA/developer might need to do. This LONG list simply states the command needed. You then need to look up the syntax in the index (why not just put the page number right there?) The list covers multiple pages, so it can be troublesome to read (if you don't know the exact terminology). I must admit that I am a beginner SQL developer, so I have only used a limited amount of the commands, but it has been very useful for the commands that I have used, and in helping me expand what I am using SQL for. I must stress that it is NOT a tutorial.