Re: Stupidity or sequences?
- From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Apr 2013 14:20:23 +0200
Johan Eriksson, 15.04.2013 13:59:
> On Mon, Apr 15, 2013 at 9:07 AM, Thomas Kellerer <thomas.kellerer@xxxxxxxxxx
> <mailto:thomas.kellerer@xxxxxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
