Re: SQL/PLUS sequence problem

From: Lee Kyoung Rok <tunnel_at_hananet.net>
Date: Tue, 14 Dec 1999 12:21:32 +0900
Message-ID: <pKi54.451$jz5.21321@news.hananet.net>

samc <samc_at_ctxopto.com.tw>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦ news:3855A168.83E0AFCF_at_ctxopto.com.tw¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> When I was created one sequence table .
> How can I to use it.
>
> my sequence :
>
> CREATE SEQUENCE abc_abc1
> INCREMENT BY 1
> START WITH 1
> MINVALUE 1
> MAXVALUE 99999999999999999999999
> NOCYCLE
> NOORDER
> NOCACHE
>

The sequence generate value by reference abc_abc1.nextval.

ex)

Insert into temp(id, name)
values (abc_abc1.nextval, 'tunnel');

*^^* Received on Mon Dec 13 1999 - 21:21:32 CST