プロジェクト

全般

プロフィール

QA #10856 » Sequence.sql

渡部 義徳, 2026-09-07 04:47 午後

 
DROP SEQUENCE NUMB_R1_9000;
DROP SEQUENCE NUMB_S3_9102;
DROP SEQUENCE NUMB_U1_9000;
DROP SEQUENCE NUMB_U3_9000;
DROP SEQUENCE NUMB_S1_9000;
DROP SEQUENCE NUMB_S2_9000;
DROP SEQUENCE NUMB_S3_9000;
DROP SEQUENCE NUMB_U5_9000;
DROP SEQUENCE NUMB_E1_9000;
DROP SEQUENCE NUMB_K1_9000;
DROP SEQUENCE NUMB_K2_9000;
DROP SEQUENCE NUMB_K3_9000;
DROP SEQUENCE NUMB_E1_2305;
DROP SEQUENCE NUMB_E1_1103;
DROP SEQUENCE NUMB_M1_9022;
DROP SEQUENCE NUMB_M2_9022;
DROP SEQUENCE NUMB_K1_9012;
DROP SEQUENCE NUMB_K2_9012;
DROP SEQUENCE NUMB_K3_9012;
DROP SEQUENCE NUMB_K4_9012;
DROP SEQUENCE NUMB_K5_9012;
DROP SEQUENCE NUMB_K6_9012;
DROP SEQUENCE NUMB_U9_9000;
DROP SEQUENCE NUMB_U6_9000;
DROP SEQUENCE NUMB_U7_9000;
DROP SEQUENCE NUMB_U8_9000;
DROP SEQUENCE NUMB_EK_9000;
DROP SEQUENCE NUMB_K8_9012;
DROP SEQUENCE NUMB_K9_9012;
DROP SEQUENCE NUMB_U2_9000;

CREATE SEQUENCE NUMB_R1_9000 START WITH 4999871850 INCREMENT BY 1 MINVALUE 4999000000 MAXVALUE 4999999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_S3_9102 START WITH 6668021 INCREMENT BY 1 MINVALUE 6500000 MAXVALUE 6699999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U1_9000 START WITH 1055546 INCREMENT BY 1 MINVALUE 1000000 MAXVALUE 5999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U3_9000 START WITH 7142181 INCREMENT BY 1 MINVALUE 7000000 MAXVALUE 7999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_S1_9000 START WITH 1843159 INCREMENT BY 1 MINVALUE 1000000 MAXVALUE 5999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_S2_9000 START WITH 6224971 INCREMENT BY 1 MINVALUE 6000000 MAXVALUE 6492999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_S3_9000 START WITH 6830995 INCREMENT BY 1 MINVALUE 6700000 MAXVALUE 6992999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U5_9000 START WITH 9327541 INCREMENT BY 1 MINVALUE 9172000 MAXVALUE 9699999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_E1_9000 START WITH 6048058900 INCREMENT BY 1 MINVALUE 6048050000 MAXVALUE 6048099999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K1_9000 START WITH 227527 INCREMENT BY 1 MINVALUE 100000 MAXVALUE 699999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K2_9000 START WITH 998270 INCREMENT BY 1 MINVALUE 997000 MAXVALUE 998998 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K3_9000 START WITH 801464 INCREMENT BY 1 MINVALUE 800000 MAXVALUE 849999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_E1_2305 START WITH 6074507887 INCREMENT BY 1 MINVALUE 6074500000 MAXVALUE 6074509999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_E1_1103 START WITH 6072013943 INCREMENT BY 1 MINVALUE 6072000000 MAXVALUE 6072099999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_M1_9022 START WITH 810405 INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_M2_9022 START WITH 994000 INCREMENT BY 1 MINVALUE 1 MAXVALUE 999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K1_9012 START WITH 80565 INCREMENT BY 1 MINVALUE 80000 MAXVALUE 99399 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K2_9012 START WITH 99400 INCREMENT BY 1 MINVALUE 99400 MAXVALUE 99999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K3_9012 START WITH 863346 INCREMENT BY 1 MINVALUE 800000 MAXVALUE 993999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K4_9012 START WITH 994000 INCREMENT BY 1 MINVALUE 994000 MAXVALUE 999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K5_9012 START WITH 308394 INCREMENT BY 1 MINVALUE 0 MAXVALUE 399989 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K6_9012 START WITH 984911 INCREMENT BY 1 MINVALUE 800000 MAXVALUE 999989 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U9_9000 START WITH 9740464 INCREMENT BY 1 MINVALUE 9000000 MAXVALUE 9999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U6_9000 START WITH 1937597 INCREMENT BY 1 MINVALUE 1000000 MAXVALUE 5999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U7_9000 START WITH 6576651 INCREMENT BY 1 MINVALUE 6000000 MAXVALUE 6999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U8_9000 START WITH 7497635 INCREMENT BY 1 MINVALUE 7000000 MAXVALUE 8999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_EK_9000 START WITH 9450255634 INCREMENT BY 1 MINVALUE 9450000000 MAXVALUE 9451999999 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K8_9012 START WITH 960753 INCREMENT BY 1 MINVALUE 960000 MAXVALUE 995000 NOCACHE ORDER;
CREATE SEQUENCE NUMB_K9_9012 START WITH 964761 INCREMENT BY 1 MINVALUE 960000 MAXVALUE 995000 NOCACHE ORDER;
CREATE SEQUENCE NUMB_U2_9000 START WITH 8703188 INCREMENT BY 1 MINVALUE 8655000 MAXVALUE 8704999 NOCACHE ORDER;
(5-5/9)