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 > > ______________________________________________________________________ Get Your Own 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=coldfusionb 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
