Re: Newbie: datatype, sequence

From: Anthony Hogan <ahogan-nospam-_at_iespana.es>
Date: Wed, 14 Aug 2002 10:22:38 +0000
Message-ID: <3D5A2F6E.E9106DD2@iespana.es>

Stefan Lintner wrote:
>
> "tojo" <TomJordanTojo_at_hotmail.com> wrote in message
> news:MPG.17c443c38cef9cf29896ab_at_news.t-online.de...
> > A sequence is not datatype, nor can you bind it to a specific field
>
> I thought that I first have to create the table and then I can do a CREATE
> SEQUENCE...
>
> I will continue searching this NG and the web.
>
> Thanks,
> Stefan

Stefan,
ID should be defined as NUMBER. The order in which you create the table / sequence is irrelevant as they are independent objects. To associate a sequence with a field you need to create the appropriate trigger. The exact mechanics of this are available, as you say, in this NG.

hth
Anthony Hogan Received on Wed Aug 14 2002 - 05:22:38 CDT