I don't know of an Oracle column type that behaves like a sequence unless she meant adding a trigger.
In Oracle, you can define a trigger on a column that will take the next sequence value and insert it into the column. The issue I have is returning that key. Since Oracle doesn't have the "Identity" or "autonumber", it also doesn't have the corresponding LAST_INSERT_ID() or SCOPE_IDENTITY() functions. Another thought is to use UUID for keys. Beth Bowden Phone: 919-541-3355 FAX: 919-541-3687 E-Mail: [EMAIL PROTECTED] Address: NIEHS, MD EC-03, P.O. BOX 12233, Research Triangle Park, NC 27709 -----Original Message----- From: Sean Corfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 21, 2006 1:55 AM To: reactor@doughughes.net Subject: Re: [Reactor For CF] Oracle support for Reactor On 2/20/06, Doug Hughes <[EMAIL PROTECTED]> wrote: > So, when working with oracle you need to create your IDs ahead of time? > > In PostgreSQL they use sequences too. However, I think you can define a > default of the next value from a sequence to a column. (It's been a while, > forgive me if I'm wrong.) > > Is there anything like that in Oracle? I just chatted to one of my Oracle DBA friends (she's in India looking after her mother right now) and she says that there is a column type that behaves like a sequence number but I suspect that isn't the default way that legacy databases are created in Oracle. For the most part, I've used a dedicated SEQUENCE as Beth indicates. Not sure how to make this clean and generic across multiple DBs. -- Sean A Corfield -- http://corfield.org/ Got frameworks? "If you're not annoying somebody, you're not really alive." -- Margaret Atwood -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
