On 2004-06-16 05:21:07 -0700, Jim wrote: > I am looking for suggestions on the best way to auto > increment a key column in a oracle table. I know I can > do this inside of Oracle by creating a sequence and > then a trigger. BUT, is it better to make DBI do this > when I insert the data?
I guess that's a matter of taste.
> If so, how would I go about
$dbh->do("insert into foo(id, ...) values(foo_id_seq.nextval, ....)");
hp
--
_ | Peter J. Holzer | Shooting the users in the foot is bad.
|_|_) | Sysadmin WSR / LUGA | Giving them a gun isn't.
| | | [EMAIL PROTECTED] | -- Gordon Schumacher,
__/ | http://www.hjp.at/ | mozilla bug #84128
pgpwgp4vqjMRk.pgp
Description: PGP signature
