Hi Jamie,
Oracle DOES have an auto-increment feature:
see CREATE SEQUENCE and also the pseudo-columns NEXTVAL and CURRVAL in any
Oracle reference book.
If you still have questions, email me...
Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA 94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED]
-----Original Message-----
From: Alex [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 02, 2001 6:45 AM
To: CF-Talk
Subject: Re: [Oracle Auto-Increment]
create a sequence then in your INSERT sql type sequencenqme.next_val.
not sure on specific syntax
Jamie Symonds <[EMAIL PROTECTED]> wrote:
Hi - I am inserting results of a form into an Oracle 8
database - in the past, while using Access, I would set the
first field of the table ("id") to "auto-number" for my
primary key. Oracle does not have an auto-increment feature
- how do I go about this? Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
