Re: oracle sequence numbers

From: Pablo Sanchez <pablo_at_dev.null>
Date: Fri, 17 Jan 2003 11:07:58 -0600
Message-ID: <Xns930667140ED89pingottpingottbah_at_216.166.71.233>


Mike Sherrill <MSherrill_at_compuserve.com> wrote in news:ijag2vgtcjgi8mj3atitda98q6povuegta_at_4ax.com:

> On Thu, 16 Jan 2003 14:35:08 -0600, Pablo Sanchez <pablo_at_dev.null>
> wrote:
>

>>Which DBMS are you thinking about?  

>
> Ones that conform to the SQL standard.

Ahm, I was looking for a specific DBMS though. Can you list a commercially available DBMS that has this support?

I'll knock off the ones that do _not_ support it:

  • up to Oracle 9iR2 - latest
  • up to Sybase ASE 12.5 - latest
  • up to SQL Server 2000 - latest

I believe that accounts for about 45% of the DBMS market-share. I don't know if DB2 has support for it.

> "TIMESTAMP" means one thing in standard SQL. It means something
> completely different to SQL Server.

and to Sybase ASE 12.5 and Oracle 9iR2.

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com
Received on Fri Jan 17 2003 - 18:07:58 CET

Original text of this message