On Jul 6, 11:28 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Jul 5, 5:46 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
>
>
>
>
> > On Jul 5, 3:30 pm, J <jdfer..._at_gmail.com> wrote:
>
> > > 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-Transact-SQL-Ken-Henderson/dp/02016...
>
> > > 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
>
> > My recommendation to you is to start with Tom Kyte's new book "Expert
> > Oracle Database Architecture".
>
> > I think you will be selling yourself short and not using oracle as it
> > is designed to be used if you only concentrate on syntax and don't
> > begin at square one.
>
> > Learn the architecture and how to develop and design scalable systems
> > first. Take a look at syntax for sql and plsql once you have read
> > Tom's book cover to cover a couple of times.
>
> > There are several followup books but that is the place to start.
>
> > All of the syntax is covered pretty well in the free oracle
> > documentation fromhttp://tahiti.oracle.com...
>
> > An alternative but not as highly recommended ( from me anyhow ) is to
> > start with the oracle concepts manual.
>
> > Get familiar with Tom's sitehttp://asktom.oracle.comandthe
> > questions and answers in it.
>
> > There's a fairly steep learning curve with oracle if you want to do
> > things well. Don't underestimate how much learning needs to be done.- Hide quoted text -
>
> > - Show quoted text -
>
> Since the OP is concerned about writing SQL I suspect the OP is more
> of a developer than a DBA and as such I would suggest starting with
> the Oracle Application Developers Guide - Fundamentals instead of
> Concepts. This manual covers many of the topics found in Concepts and
> DBA Administration but with more emphasis on using rather than
> managing the objects.
>
> Tom's Book is very good but I think Tom expects you to be familiar
> with Oracle and PL/SQL since it is not a primer on SQL or PL/SQL so I
> would suggest reviewing the first few chapters of the SQL manual which
> cover the Oracle provided functions like to_date, to_char, upper(_),
> etc... and then reading the PL/SQL manual before reading a book.
>
> HTH --Mark D Powell --- Hide quoted text -
>
> - Show quoted text -
This is my first post on here. I like a corny looking little book
called sql cookbook by pete cassidy. it's full of usable examples.
the index is lousy. and it's a bit old and out of date. it stops at
inline queries. but still helpful for writing basic ad hoc sql,
creating sql from sql, and many others. it's not cheap either. i've
seen it listed for about $50 more than original list price on amazon
and ebay.
Received on Fri Jul 06 2007 - 11:11:48 CDT
