Re: tool: convert classic oracle sql to ansi?
From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 18 Dec 2008 00:27:12 -0800
Message-ID: <1229610751.191729@bubbleator.drizzle.com>
>> 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
Date: Thu, 18 Dec 2008 00:27:12 -0800
Message-ID: <1229610751.191729@bubbleator.drizzle.com>
steph wrote:
> On 16 Dez., 21:56, 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
> > 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:
SELECT *
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:
SELECT *
FROM t1 INNER JOIN t2
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Dec 18 2008 - 02:27:12 CST