Re: tool: convert classic oracle sql to ansi?

From: DA Morgan <>
Date: Thu, 18 Dec 2008 00:27:12 -0800
Message-ID: <>

steph wrote:

> On 16 Dez., 21:56, ddf <> wrote:

>> On Dec 16, 11:18 am, steph <> 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
> Yes, correct: a tool to convert oracle join syntax to ansi join syntax
> - that's what I'm looking for!

It would take less time to write your own with perl than it has taken to amuse everyone here by asking the question. The vast majority of us, knowing Oracle, consider the ANSI joins a waste of perfectly good keystrokes.

Lets see:
FROM t1,t2
WHERE t1.col1 = t2.col2;

Replace the comma with ' INNER JOIN ' (add ten keystrokes) Replace WHERE with ON (subtract three keystrokes) and it looks like this:

ON t1.col1 = t2.col2;

And that is worth your time and your employer's money? And one is clearer than the other?
I'd love to hear the explanation.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Thu Dec 18 2008 - 02:27:12 CST

Original text of this message