Re: tool: convert classic oracle sql to ansi?
Date: Wed, 17 Dec 2008 03:21:19 -0800 (PST)
Message-ID: <68b91345-e94c-4fe4-b43f-36016b0b75d4@s9g2000prg.googlegroups.com>
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! Received on Wed Dec 17 2008 - 05:21:19 CST