Re: Some SQL Help Please

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Sun, 13 Jun 2004 19:07:31 GMT
Message-ID: <TB1zc.38043$%i1.14198@edtnps89>

Charlie Bursell wrote:

> Using Oracle 8, so no ANSI joins
>

Just hints (perhaps others will be kind enough to work this with you)

Try writing it using ANSI joins and then look at the docco to map the 'ANSI' back to Oracle's outer join capability.
Ask yourself why you are still using Oracle8. At least for test purposes, you could create an Oracle9i or Oracle10g harness and check it out. If this is a one-off question, possibly use that harness with DB links back to the Oracle8 database.

/Hans Received on Sun Jun 13 2004 - 14:07:31 CDT