Doesn't oracle support @@identity?
-----Original Message----- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Thursday, 3 January 2002 3:19 PM To: CF-Talk Subject: Re: Database AutoNum column Not directly. But you can create a SEQUENCE. Then you use the value from that sequence in your query: INSERT INTO table (pk,value,value) VALUES (sequencename.nextval,'value','value') (What I DON'T know how to do is use that same value in subsequent queries without selecting it from the table I just inserted...) > Is there an autonum feature in oracle 8i, if so how do I define it? > > Thanks > Sam > > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
