Re: tool: convert classic oracle sql to ansi?

On Tue, 16 Dec 2008 12:56:36 -0800 (PST), ddf <oratune_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 Received on Tue Dec 16 2008 - 17:29:08 CST