Re: tool: convert classic oracle sql to ansi?
Date: Tue, 16 Dec 2008 16:03:34 -0800 (PST)
On Dec 17, 8:29 am, sybra..._at_hccnet.nl wrote:
> On Tue, 16 Dec 2008 12:56:36 -0800 (PST), ddf <orat..._at_msn.com> wrote:
> >On Dec 16, 11:18 am, steph <stepha..._at_yahoo.de> wrote:
> >> Hi Group,
> >> I do this manually from time to time - but maybe there's a better
> >> way ...
> >> Does anybody know of a way, tool or whatever to convert classic oracle
> >> sql-statements to ansi-sql and vice versa? Maybe the database is able
> >> to do so?
> >> Thanks,
> >> Stephan
> >"Classic" Oracle SQL? Hmmm ...
> >Selecte *
> >From Ye Olde Dual;
> >Or are you asking for a 'tool' to 'translate' Oracle join syntax (such
> >as outer joins) into the ANSI equivalent?
> >I know of no such tool, but, I've been wrong before.
> >David Fitzjarrell
> ANSI joins are unreadable anyway.
> Sybrand Bakker
> Senior Oracle DBA
I agree, give me the classic Oracle join syntax any day Received on Tue Dec 16 2008 - 18:03:34 CST