look into sequence obj. once you create one seq1(with start valule and
increment value...), you could get the next seql.nextval. certainly
write a function or trigger would mimic the identity in sql svr.
"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 Wed Sep 26 2001 - 20:48:11 CDT
