Re: tool: convert classic oracle sql to ansi?

On 17 Dez., 00:29, 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

Sybrand, thanks for your opinion - but actually when being confronted with a 100s-of-lines sql i find ansi-joins more readable. Why? Because tables and associated joins tend to be on the same line. But what is good for me needn't be good for you and I don't want to start a discussion about this. Received on Wed Dec 17 2008 - 05:19:54 CST