COOLX World
4,564,971 th visitor since 2017.2.1 ( Today : 170 )
Programming
No. 12
Name. coolx
Subject. Sequence 사용
Main Cate. Oracle
Sub Cate.
Date. 2004-07-02 08:51
Hit. 4475 (211.219.39.230)
File.
생성,

CREATE SEQUENCE seq_name
INCREMENT by 1
START WITH 100
MAXVALUE 99999 (NOMAXVALUE)
CYCLE (NOCYCLE)
[CACHE n] (NOCACHE)
;

사용 :
insert into a values(seq_name.NextVal);

NextVal과 CurrVal이 있음..


보기
desc user_objects

select object_name
from user_objects
where object_type like '%SEQ%'



삭제
drop sequence [seq]

[바로가기 링크] : http://coolx.net/cboard/develop/12


swindler currVal은 nextVal을 한 세션에서만 사용 가능하므로
select LAST_NUMBER from user_sequences where SEQUENCE_NAME = 'xxx' 로 현재값을 알아볼수 있음		 2005-12-22
Name
Password
Comment
 [Modify] [Delete] [Reply] [List] 
Copyright © 1999-2017, swindler. All rights reserved. 367,611 visitor ( 1999.1.8-2004.5.26 ), 2,405,771 ( -2017.01.31)

  2HLAB   2HLAB_Blog   RedToolBox   Omil   Omil_Blog