On Jul 6, 4:47 pm, DA Morgan <damor..._at_psoug.org> wrote:
> batso wrote:
> > 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.
>
> You can find current examples in abundance and for free by going to
> Morgan's Library atwww.psoug.org. All ways free and always available
> as a service of an Oracle user group.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org
What a freaking surprising reply.
Received on Fri Jul 06 2007 - 17:52:07 CDT
