You cannot select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
|
-- 자동차 등록 원부(갑) 마스터 ID 시퀀스
|
|
-- CLFB000000000001, CLFB000000000002, ... 형태로 생성
|
|
CREATE SEQUENCE seq_car_ledger_frmbk
|
|
START WITH 1
|
|
INCREMENT BY 1
|
|
MINVALUE 1
|
|
MAXVALUE 9999999999
|
|
CACHE 1000
|
|
NOCYCLE;
|
|
|
|
-- SELECT CONCAT('CLFB', LPAD(NEXTVAL(seq_car_ledger_frmbk), 16, '0'));
|