From: Martijn Tonies
Date: September 16 2005 2:34pm
Subject: Re: Differences Between ORACLE SQL PLus and MYSQL SQL
List-Archive: http://lists.mysql.com/mysql/189175
Message-Id: <01b301c5bacb$bfe1f070$c802a8c0@martijnws>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> Could you please tell us what are the differences
> between ORACLE SQL plus and MYSQL SQL? We developed

"oracle sql plus" is a client side application to execute SQL statements.

"oracle sql" is Oracles version of standard SQL (which is not standard)
and "mysql sql" is MySQLs version of standard SQL, which is not
standard either.

> application using ColdFusion with Oracle. Now I like
> to point my application to mysql database. How do I
> fix my application to work with Mysql?

Remove any Oracle specific syntax, try to find the SQL standard
syntax for it - if available - and if that doesn't work, try the MySQL
version of the SQL.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com