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