Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Newbie: Sample SQL Code
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