Re: Tool to convert SQl queries to oracle or vice versa

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 23 Jan 2002 12:44:32 -0000
Message-ID: <3c4eb033$0$8506$ed9e5944@reading.news.pipex.net>

"Chris" <christianboivin1_at_hotmail.com> wrote in message news:da20daf0.0201221334.62e05946_at_posting.google.com...
> Hi
>
> If you can, just write standard ansi92 SQL queries
> because its understand by both DB

The first trouble with this is that it isn't really true. Of course both products support base level SQL92 - but that is all you can really rely on. As far as I can tell the ANSI Join syntax for example is LEFT [OUTER] JOIN ON. Oracle before 9i will not recognize this syntax. SQL server will.

The second trouble of course is that you are denying yourself features and performance at the ,dubious, benefit of portability.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Wed Jan 23 2002 - 06:44:32 CST