Home -> Mailing Lists -> Oracle-L -> Re: Stupidity or sequences?

Re: Stupidity or sequences?

From: Thomas Kellerer <thomas.kellerer_at_mgm-tp.com>
Date: Mon, 15 Apr 2013 14:20:23 +0200
Message-ID: <516BF087.6020108_at_mgm-tp.com> 






Johan Eriksson, 15.04.2013 13:59:

> On Mon, Apr 15, 2013 at 9:07 AM, Thomas Kellerer <thomas.kellerer_at_mgm-tp.com <mailto:thomas.kellerer_at_mgm-tp.com>> wrote:
>
>     Almost all DBMS support sequences nowadays.
>     Hiding the specific syntax of each DBMS to obtain the next sequence value isn't really hard.
>
>     Avoiding them means to settle on the limitations of one or two (limited) DBMS.
>
>
> Not that familiar with other DB's , but have they advanced further than using identity and auto_increment?





Yes. To my knowledge the following DBMS support sequences (the way Oracle does):



    
  
  •   Postgres
  
  •   DB2
  
  •   SQL Server 2012
  
  •   Firebird (called "generators" there)
  
  •   Informix
  
  •   Ingres
  
  •   MonetDB
  
  •   Vertica
  
  •   Cubrid
  
  •   NuoDB
  
  •   Apache Derby
  
  •   H2 Database
  
  •   HSQLDB





Regards


Thomas


--
http://www.freelists.org/webpage/oracle-l


Received on Mon Apr 15 2013 - 14:20:23 CEST












Original text of this message