Community technical support mailing list was retired 2010 and replaced with a professional technical support team. For assistance please contact: Pre-sales Technical support via email to sales@march-hare.com.
> -----Original Message----- > From: cvsnt-bounces at cvsnt.org > [mailto:cvsnt-bounces at cvsnt.org] On Behalf Of Tony Hoyle > Sent: Tuesday, January 10, 2006 10:13 AM > To: cvsnt at cvsnt.org cvsnt downloads at march-hare.com @CVSNT on Twitter CVSNT on Facebook > Subject: Re: [cvsnt] Re: Repository auditing with Oracle > > Paulo Soares wrote: > > > All the databases (maybe not sqllite) provide sequences that can be > > queried and auto-incremented in an atomic way. Oracle also > has rowid > > On the contrary - Mysql, Mssql, Access, Sqlite... > autoincrement support > is much more prevalent - only oracle seems to not support it. > Oracle does that with sequences. I have code where I get the next sequence number and use that number as key for several tables. You are right that it's virtually impossible to have common queries even if they all speak SQL; what I don't understand is the reasoning you make that the only way to do this is with a DB that supports some kind of auto-increment leaving Oracle outside of the equation as if Oracle is some kind of an obscure DB. I'm not really complaining (perhaps just a bit...), it's not critical for me and as far as CVS goes I've yet to see any program this good. Paulo