Re: D2k - How to create a sequence?

From: Claire M. <cmarcoux_at_webnet.qc.ca>
Date: Fri, 12 Nov 1999 22:33:28 GMT
Message-ID: <YA0X3.386$ws.9630469_at_news1.mtl.metronet.ca>


Hi.

The way to do it is:
[Quoted] In your SQLPLUS Editor

Create sequence s_dept_id
Increment by 1
start with 1
maxvalue 999999
nocache
nocycle;

And then it is done.
Good Luck
Claire M.

Ken Halsted a écrit dans le message ...
>I did this once and forgot how I did it, doh!
>
>How do you create a sequence definition in designer 2000. I have my column
>defined in the ERD as a Number 10,0 and now I need to define a sequence to
>associate with the column. At what point is this supposed to be created
and
>how?
>
>Thanks for your help,
>
>Ken.
>
>
Received on Fri Nov 12 1999 - 23:33:28 CET

Original text of this message