Closed dhkdtld37 closed 6 months ago
create sequence test.sam_seq start with 1 increment by 1 maxvalue 999 cycle;
select lpad( cast(nextval(test.sam_seq) as char ) ,3,'0') as seqno ;
lastval(test.sam_seq);현재값 확인
insert into 테이블명
(select nextval(test.sam_seq)),## ,## );
alter sequence test.sam_seq restart 1;
auto_increment
max+1
별도 채번 테이블 / 시퀀스
2024-03-19 6차 멘토링