Didn't we just answer this?? Anyhoo...no. There is the concept of sequences though.
To quote Tony: "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')" Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Allaire Alliance Partner www.allaire.com ----- Original Message ----- From: "sam komolafe" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 03, 2002 8:52 AM Subject: Database AutoNum column > Hi guys > > Is there an autonum feature in oracle 8i, if so how do I define it? > > Thanks > Sam komolafe > > > ______________________________________________________________________ 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
