SQL 시퀀스 사용 예제

create table u2_member (

  num number,

  id varchar2(20),

  pw varchar2(10),

  name varchar2(10),

  age number,

  grade varchar2(20),

  company varchar2(20),

  addr varchar2(20),

  phone varchar2(15),

  hp varchar2(20)

);

//시퀀스 만들기

CREATE SEQUENCE seq_U2_Member

INCREMENT BY 1

START WITH 1

MAXVALUE 9999

NOCACHE

NOCYCLE;

//시퀀스로 입력하기

insert into u2_member

values( seq_U2_Member.nextval,'U2','U2PASS','개똥',10,'실장','U2','인천','02-111-2222','010-5555-5555');

//시퀀스 변경하기

ALTER SEQUENCE  seq_U2_Member

INCREMENT BY 1

CACHE 40;

select * from u2_member ;​