Re: Will an SQL where statement with an OR clause work?

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Mon, 09 Aug 2004 14:34:38 GMT
Message-ID: <2YLRc.74834$T_6.65976@edtnps89>

G wrote:

> Thanks for the help and the book recomendation, and yes the or
> statement works as I expected. Is that book good for beginners as well
> as advance users? I write programs in Java/.Net/ASP that hit Oracle
> DBs and would like a good book with sound examples.

Two books (other than the Oracle docs known as the 'Application Developer' manuals at http://docs.oracle.com) that I think belong in every Oracle developer's library:

Effective Oracle by Design by Thomas Kyte http://www.amazon.com/exec/obidos/tg/detail/-/0072230657/102-0490673-9231311
Mastering Oracle SQL, 2nd Edition http://www.oreilly.com/catalog/0596006322/

Both are great for beginners and experts alike. Both have examples. Both teach basics, then build up to very advanced techniques. Both leave you with a working toolkit. Both help you code faster and write faster code.

And both provide use SQL*Plus for all examples, allowing you develop and test the pieces that you can then cut & paste into your programs.

/Hans Received on Mon Aug 09 2004 - 09:34:38 CDT