Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ROWID is IDENTITY?

Re: ROWID is IDENTITY?

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Wed, 26 Sep 2001 20:07:04 +0100
Message-ID: <9ot91n$44i$1@sun-cc204.lut.ac.uk>


No, you are looking for a SEQUENCE which you make auto-incrementing for your column by creating a before insert row TRIGGER.

Andy
"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 - 14:07:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US