ROWID is IDENTITY?

From: Jay Valdez <jay_at_dontspamme.com>
Date: Wed, 26 Sep 2001 11:35:17 -0700
Message-ID: <bgps7.2065$3x.7114@news.bc.tac.net>

Hello,

As in the previous post. I am an SQL Server person doing some experimental/proof of concept work in Oracle.

I just want to know what the equivalent of IDENTITY (automatically incrementing Long Int) is Oracle is it ROWID?

Here is the sample DDL for SQL Server 7.

/****** Object: Table [dbo].[TBLTODOLIST] Script Date: 11/20/2000 10:47:58 AM ******/
CREATE TABLE [dbo].[TBLTODOLIST] (
[TASKID] [int] IDENTITY (1, 1) NOT NULL ,
[USERNAME] [varchar] (50) NULL ,
[TRAININGITEMID] [int] NULL ,
[COMMENT] [text] NULL ,
[TRAININGPROGRAM] [varbinary] (16) NULL ,
[SEQUENCENO] [smallint] NULL ,
[TIMEINDEX] [datetime] NULL

)

Jay Received on Wed Sep 26 2001 - 13:35:17 CDT