Re: ROWID is IDENTITY?

From: Jay Valdez <jay_at_dontspamme.com>
Date: Tue, 2 Oct 2001 10:25:17 -0700
Message-ID: <DOmu7.2106$3x.7428@news.bc.tac.net>

Hello,

Thanks for all your responses.

Well I created several SEQUENCES and several TRIGGERS and they all work quite well.

Jay

"Jay Valdez" <jay_at_dontspamme.com> wrote in message news:bgps7.2065$3x.7114_at_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 Tue Oct 02 2001 - 12:25:17 CDT