Re: Define sequence as NUMBER or LONG

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 16 Mar 2000 22:01:21 +0100
Message-ID: <953243401.22737.1.pluto.d4ee154e@news.demon.nl>

sequence usually is implemented as number(10). I don't think you want LONG as a LONG in Oracle is an unlimited string variable.

Hth,

Sybrand Bakker, Oracle DBA

Maggie <maggiezhou_at_hotmail.com> wrote in message news:8arb4a$erp$1_at_web1.cup.hp.com...
> Generate Sequence number from 1 increment with1. In this case, I define
> this sequence data type as int but Oracle convert to NUMBER(38). I
thought
> if I define LONG might be better. What do you think?
>
>
Received on Thu Mar 16 2000 - 15:01:21 CST