Hi Everyone,

I've done some searching on the forum/group here and I'm having a hard
time trying to find a book that suits my needs. I'm looking for a
book that I can use/reference to find how to use all of the various
SQL commands in Oracle. I've had prior experience in Transact-SQL in
my last job writing against a MS SQL Server. The book that I found
and love is "The Guru's Guide to Transact-SQL" by Ken Henderson. This
book, IMHO, is the best, definite guide on how to query a database.

Link here:
http://www.amazon.com/Gurus-Guide-Tr...3663381&sr=8-2

I'm trying to find this same book for Oracle, but I'm not sure if one
exists. What I'm not looking for is a book that teaches you the
administrative side of an Oracle server/db, database tuning, etc. I'm
looking for a book that teaches all of the SQL commands (select,
insert, pivot tables, subquerying, etc), how they work, and what the
syntax is.

Is there anything out there that has this?

Thanks

Jeff

J wrote:
There is no such book in Oracle as the product is far too rich in terms
of features.

The books I'd recommend are any written by Tom Kyte but for the full
documented capabilities go to http://tahiti.oracle.com.

For demos you can cut and paste to help you learn to use it:
http://www.psoug.org and click on Morgan's Library.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

On Jul 5, 5:10 pm, DA Morgan <damor... (AT) psoug (DOT) org> wrote:
Yes. It is called the 'Oracle SQL Reference' manual. The manual
provides details about each command, including all the syntax variants
AND examples.

I realize it has two strikes against it - it's a manual, not a book;
and it's free. Still, the information is invaluable. If you don't
know and understand the contents of that manual, you simply do not
know Oracle from a developer's perspective, no matter which other
books you have read.

For 10g Release 2, it's at http://download.oracle.com/docs/cd/B...b14200/toc.htm


In addition to that, I highly recommend


1) From APress at http://oracle.apress.com

Expert Oracle Database Architecture: 9i and 10g Programming Techniques
and Solutions
By Thomas Kyte. ISBN: 1590595300

Mastering Oracle SQL and SQL*Plus
By Lex de Haan. ISBN: 1590594487

Cost-Based Oracle Fundamentals
By Jonathan Lewis. ISBN: 1590596366


2) From OReilly press, SQL area, at http://www.oreilly.com/pub/topic/sql

The Art of SQL
By Stéphane Faroult, Peter Robson

SQL Cookbook
By Anthony Molinaro

3) From OReilly press, Oracle area, at http://oracle.oreilly.com

Mastering Oracle SQL , Second Edition
By Sanjay Mishra, Alan Beaulieu


/Hans