Path: text.usenetserver.com!out01a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!n60g2000hse.googlegroups.com!not-for-mail
From:  "fitzjarrell@cox.net" <fitzjarrell@cox.net>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Advanced books wanted
Date: Thu, 21 Jun 2007 11:24:00 -0700
Organization: http://groups.google.com
Lines: 39
Message-ID: <1182450240.949898.77230@n60g2000hse.googlegroups.com>
References: <1182447396.188492.86140@o61g2000hsh.googlegroups.com>
NNTP-Posting-Host: 138.32.32.166
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1182450241 1971 127.0.0.1 (21 Jun 2007 18:24:01 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 21 Jun 2007 18:24:01 +0000 (UTC)
In-Reply-To: <1182447396.188492.86140@o61g2000hsh.googlegroups.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: n60g2000hse.googlegroups.com; posting-host=138.32.32.166;
   posting-account=B_KC8Q0AAADcSTVy4DZ59utFaLrVLOo4
Xref: usenetserver.com comp.databases.oracle.misc:248398
X-Received-Date: Thu, 21 Jun 2007 14:24:01 EDT (text.usenetserver.com)

Comments embedded.
On Jun 21, 12:36 pm, General Fear <richma...@earthlink.net> wrote:
> I am using 10g.
>
> I wanted to 3 types of books. If not books, then maybe a web page that
> shows the list below.
>
> 1.) Advanced SQL. I wanted something that goes beyond the typical
> "this is what a where clause is ".  At my firm, SQL statements can get
> very complex even for the easiest reports. So I am interested in
> learning how to push the limits of SQL.
>

Joe Celko,"SQL for Smarties".

> 2.) Debug. Is there a source of information that shows how to go about
> debugging SQL code? Because of my background, I am not as fluent in
> SQL. So I am okay with my stuff, but, spotting what is wrong with
> someone elses SQL is a bit difficult for me at the moment.
>

Cary Millsap, "Optimizing Oracle Performance".

> 3.) How to optimize SQL code. I wanted a book or web page that shows
> how to make SQL and PL/SQL better. If some code is slow or has another
> problem I would like to be able to improve things.
>

See above.  See also:

Jonathan Lewis, "Cost-Based Oracle Fundamentals"
Steven Feuerstein, "PL/SQL Programming", Fourth Edition
Thomas Kyte, "Expert Oracle Database Architecture"

> Thanking you in advance.


David Fitzjarrell