Re: tool: convert classic oracle sql to ansi?

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