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_at_edtnps89>
Date: Sun, 13 Jun 2004 19:07:31 GMT
Message-ID: <TB1zc.38043$%i1.14198_at_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 - 21:07:31 CEST