26 lines
426 B
SQL
26 lines
426 B
SQL
-- Create sequence 陵젬땐데뵀
|
|
create sequence upop_sequence
|
|
minvalue 1
|
|
maxvalue 99999999
|
|
start with 00000001
|
|
increment by 1
|
|
cache 200
|
|
cycle;
|
|
|
|
-- Create sequence 陵젬툽늴뵀
|
|
create sequence upop_batno_sequence
|
|
minvalue 1
|
|
maxvalue 9999
|
|
start with 0001
|
|
increment by 1
|
|
cache 100
|
|
cycle;
|
|
|
|
-- Create sequence 직彊뵀
|
|
create sequence jrn_no_sequence
|
|
minvalue 1
|
|
maxvalue 9999999999
|
|
start with 0000000001
|
|
increment by 1
|
|
cache 100
|
|
cycle; |