Re: tool: convert classic oracle sql to ansi?
Date: Wed, 17 Dec 2008 00:29:08 +0100
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?
>"Classic" Oracle SQL? Hmmm ...
>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.
ANSI joins are unreadable anyway.
Senior Oracle DBA Received on Tue Dec 16 2008 - 17:29:08 CST