Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie: Sample SQL Code

Re: Newbie: Sample SQL Code

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Fri, 15 Jun 2007 04:17:13 -0700
Message-ID: <1181906233.989747.276790@q66g2000hsg.googlegroups.com>


On Jun 15, 6:44 am, General Fear <richma..._at_earthlink.net> wrote:
> I am learning SQL and PL/SQL. I was interested in finding some sample
> SQL code.
>
> I know the basics so I am more interested in Advance complex SQL.
>
> Any suggestions?
>
> ..

What seems like basic SQL to some people is advanced, complex SQL to others. If you are looking for book suggestions, Joe Celko's "SQL For Smarties: Advanced SQL Programming" is a good reference, as is Guy Harrison's "Oracle SQL High-Performance Tuning". Oracle's SQL Reference book is also quite helpful:
  http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14200/toc.htm

Many samples of advanced, complex SQL have been posted in this group, along with the comp.databases.oracle.misc group. These samples can be found by Google searches:
http://groups.google.com/group/comp.databases.oracle.misc/search?group=comp.databases.oracle.misc&q=SELECT http://groups.google.com/group/comp.databases.oracle.misc/search?group=comp.databases.oracle.server&q=SELECT

The threads that discuss analytical functions are typically the more advanced samples. If you encounter some of my posts, you will usually find descriptions of how the solution was developed, possibly with 10 different SQL constructs, developed by several different authors (Michel Cadot, Maxim Demenko, Robert Klemme, EscVector, DA Morgan, and many others).

Good luck,

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Fri Jun 15 2007 - 06:17:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US