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.
VMIS-interface/ddl/vips/seq_car_ledger_frmbk_dtl.sql

12 lines
333 B
SQL

-- 자동차 등록 원부(갑) 상세 ID 시퀀스
-- CLFD000000000001, CLFD000000000002, ... 형태로 생성
CREATE SEQUENCE seq_car_ledger_frmbk_dtl
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 9999999999
CACHE 1000
NOCYCLE;
-- SELECT CONCAT('CLFD', LPAD(NEXTVAL(seq_car_ledger_frmbk_dtl), 16, '0'));