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 -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
