On Fri, 16 Sep 2005 10:32:23 -0400
> You asked basically two questions:
> a) what are the differences between ORACLE SQL plus and MYSQL?
> depends on how they are with MySQL already. One well-known point on
> MySQL and Oracle differ is in how to define a JOIN in a SQL
> MySQL works best if you use the explicit "[INNER|LEFT|RIGHT] JOIN
> ..." format. AFAIK, Oracle does not support this syntax.
All these questions are also dependant on which version of which
software you are using. In Oracle 8i the above is certainly true, you
have to use the doofy (+) syntax for outer joins, etc. In Oracle
10g though the more verbose syntax is supported:
You can do LEFT INNER, RIGHT INNER, LEFT OUTER, RIGHT OUTER, FULL
OUTER, etc. using the same syntax as MySQL.
I'm not sure but some versions of MySQL also had different results
from Oracle depending on how you defined the join condition in an
OUTER join. So what version of MySQL you choose also has consequences
on portability (e.g. sub-queries, views, etc)
There are enough little differences between all DBMS's that make
porting a real challenge. Bottom line, you're going to have to do a
LOT of research and testing.
I would seriously consider looking at a database abstraction layer.
In ColdFusion I have no idea what is available, but for PhP you'd want
to look at something like ADOBD (http://adodb.sourceforge.net) or