Re: [phplib] database abstraction From: Adam Thompson (athompso <email protected>)
Date: 06/30/00

----- Original Message -----
From: "Carl Youngblood" <carly <email protected>>
To: "'Jeff Kolber'" <jeff <email protected>>
Cc: <phplib <email protected>>
Sent: Saturday, July 01, 2000 5:18 AM
Subject: RE: [phplib] database abstraction

> 1) You will have to do some changing of your SQL statements just to
get
> them to parse correctly in Oracle (for example there are differences
in
> CREATE TABLE statements, Oracle doesn't have "auto_increment" columns,
> number data types work differently, many of the function calls are
> different, dates are formatted differently etc.)

Unfortunately, the guys over at Oracle don't seem to be very concerned
about the SQL92 standard, or even the SQL89 standard. "Standard" SQL
generally doesn't work right. The changes are all minor, but very
annoying.

Oracle *does* support the notion of an auto-increment column. If you're
still working in Oracle 7, you'll have to create a helper SEQUENCE
object, and then tie them together using PL/SQL. Oracle 7.3.something
made this a little more transparent. AFAIK, 8i supports it explicitly.

(Other than that, I agree with your message. Oracle is nice if you
*start* there and take full advantage of it. Porting directly from
MySQL to Oracle is kind of pointless.)

-Adam Thompson
 athompso <email protected>

---------------------------------------------------------------------
To unsubscribe, e-mail: phplib-unsubscribe <email protected>
For additional commands, e-mail: phplib-help <email protected>