[cvsnt] Re: Repository auditing with Oracle

Paulo Soares psoares at consiste.pt
Tue Jan 10 10:41:35 GMT 2006


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



More information about the cvsnt mailing list
Download the latest CVSNT, TortosieCVS, WinCVS etc. for Windows 8 etc.
@CVSNT on Twitter   CVSNT on Facebook