#####说明#####
操作步骤如下：
–创建分区表 注：分区表创建时，要根据实际情况创建主键，可以不创建主键，可以用联合主键，但分区列必须包含在主键中
–创建序列 注：要根据表中当前自增值的最大值来确定序列的起始值，创建序列的语句中“START WITH”定义起始值
–分区表插入数据时，insert语句引用序列
–序列的使用方法：
#查询序列的当前值 select SEQ_TBL_LIS_DETAIL3.currtval;
#查询序列的下一个值 select SEQ_TBL_LIS_DETAIL3.nextval;
a. 表定义可通过设置 “字段名 IDENTITY (自增起始值,步长)”，insert后通过select GLOBAL_IDENTITY() as MaxID 获取最大值
b. 查询时通过SELECT LAST_INSERT_ID 方式获取最大值

—分区表示例

CREATE TABLE “SYSDBA”.“TBL_LIS_DETAIL3”
(
“ID” BIGINT NOT NULL,
“LAST_UPDATE_DTIME” TIMESTAMP(6) NOT NULL,
“ORG_CODE” VARCHAR2(50) NOT NULL,
“EVENT_NO” VARCHAR2(128),
“REPORT_FORM_NO” VARCHAR2(128) NOT NULL,
“SERIAL_NO” VARCHAR2(128),
“CLASS_CODE” VARCHAR2(128),
“CLASS_NAME” VARCHAR2(128) NOT NULL,
“RESULT_TYPE” VARCHAR2(128),
“RESULT_VALUE” VARCHAR2(512),
“RESULT_UNIT” VARCHAR2(20),
“NORM_LOWER_LIMIT” VARCHAR2(4000),
“NORM_UPPER_LIMIT” VARCHAR2(4000),
“NORM_VALUE_NOTES” VARCHAR2(4000),
“RESULT_INTERPRE” VARCHAR2(4000),
“EXAMINE_WAY” VARCHAR2(512),
“RECOGNITION” VARCHAR2(256),
“EXAM_INS_ITEM_CODE” VARCHAR2(2000),
“EXAM_INS_ITEM_NAME” VARCHAR2(2000),
“CREATE_TIME” TIMESTAMP(6),
“LAST_MODIFIED_DATE” TIMESTAMP(6),
“IS_DISCARD” INTEGER,
“CHECK_SPT_ITEM_CODE” VARCHAR(2000),
NOT CLUSTER PRIMARY KEY(“ORG_CODE”, “CLASS_NAME”, “REPORT_FORM_NO”))
PARTITION BY RANGE(“LAST_UPDATE_DTIME”)
SUBPARTITION BY HASH(“REPORT_FORM_NO”) SUBPARTITION TEMPLATE
SUBPARTITIONS 16
(
PARTITION “A_LESS” VALUES LESS THAN(DATETIME’2020-01-01 00:00:00’) ,
PARTITION “A_2020q1” VALUES LESS THAN(DATETIME’2020-04-01 00:00:00’) ,
PARTITION “A_2020q2” VALUES LESS THAN(DATETIME’2020-07-01 00:00:00’) ,
PARTITION “A_2020q3” VALUES LESS THAN(DATETIME’2020-10-01 00:00:00’) ,
PARTITION “A_2020q4” VALUES LESS THAN(DATETIME’2021-01-01 00:00:00’) ,
PARTITION “A_2021q1” VALUES LESS THAN(DATETIME’2021-04-01 00:00:00’),
PARTITION “A_2021q2” VALUES LESS THAN(DATETIME’2021-07-01 00:00:00’),
PARTITION “A_2021q3” VALUES LESS THAN(DATETIME’2021-10-01 00:00:00’),
PARTITION “A_2021q4” VALUES LESS THAN(DATETIME’2022-01-01 00:00:00’),
PARTITION “A_2022q1” VALUES LESS THAN(DATETIME’2022-04-01 00:00:00’),
PARTITION “A_2022q2” VALUES LESS THAN(DATETIME’2022-07-01 00:00:00’),
PARTITION “A_2022q3” VALUES LESS THAN(DATETIME’2022-10-01 00:00:00’),
PARTITION “A_2022q4” VALUES LESS THAN(DATETIME’2023-01-01 00:00:00’),
PARTITION “A_2023q1” VALUES LESS THAN(DATETIME’2023-04-01 00:00:00’),
PARTITION “A_2023q2” VALUES LESS THAN(DATETIME’2023-07-01 00:00:00’),
PARTITION “A_2023q3” VALUES LESS THAN(DATETIME’2023-10-01 00:00:00’),
PARTITION “A_2023q4” VALUES LESS THAN(DATETIME’2024-01-01 00:00:00’),
PARTITION “A_2024q1” VALUES LESS THAN(DATETIME’2024-04-01 00:00:00’),
PARTITION “A_2024q2” VALUES LESS THAN(DATETIME’2024-07-01 00:00:00’),
PARTITION “A_2024q3” VALUES LESS THAN(DATETIME’2024-10-01 00:00:00’),
PARTITION “A_2024q4” VALUES LESS THAN(DATETIME’2025-01-01 00:00:00’),
PARTITION “A_2025q1” VALUES LESS THAN(DATETIME’2025-04-01 00:00:00’),
PARTITION “A_2025q2” VALUES LESS THAN(DATETIME’2025-07-01 00:00:00’),
PARTITION “A_2025q3” VALUES LESS THAN(DATETIME’2025-10-01 00:00:00’),
PARTITION “A_2025q4” VALUES LESS THAN(DATETIME’2026-01-01 00:00:00’),
PARTITION “A_2026q1” VALUES LESS THAN(DATETIME’2026-04-01 00:00:00’),
PARTITION “A_2026q2” VALUES LESS THAN(DATETIME’2026-07-01 00:00:00’),
PARTITION “A_2026q3” VALUES LESS THAN(DATETIME’2026-10-01 00:00:00’),
PARTITION “A_2026q4” VALUES LESS THAN(DATETIME’2027-01-01 00:00:00’),
PARTITION “A_2027q1” VALUES LESS THAN(DATETIME’2027-04-01 00:00:00’),
PARTITION “A_2027q2” VALUES LESS THAN(DATETIME’2027-07-01 00:00:00’),
PARTITION “A_2027q3” VALUES LESS THAN(DATETIME’2027-10-01 00:00:00’),
PARTITION “A_2027q4” VALUES LESS THAN(DATETIME’2028-01-01 00:00:00’),
PARTITION “A_MORE” VALUES LESS THAN(MAXVALUE)
) ;

—创建序列
CREATE SEQUENCE “SYSDBA”.“SEQ_TBL_LIS_DETAIL3” INCREMENT BY 1 START WITH 1;

–插入语句引用序列
insert into “SYSDBA”.“TBL_LIS_DETAIL3” (“ID”,
“LAST_UPDATE_DTIME”,
“ORG_CODE”,
“EVENT_NO”,
“REPORT_FORM_NO”,
“SERIAL_NO”,
“CLASS_CODE”,
“CLASS_NAME”,
“RESULT_TYPE”,
“RESULT_VALUE”,
“RESULT_UNIT”,
“NORM_LOWER_LIMIT”,
“NORM_UPPER_LIMIT”,
“NORM_VALUE_NOTES”,
“RESULT_INTERPRE”,
“EXAMINE_WAY”,
“RECOGNITION”,
“EXAM_INS_ITEM_CODE”,
“EXAM_INS_ITEM_NAME”,
“CREATE_TIME”,
“LAST_MODIFIED_DATE”,
“IS_DISCARD”,
“CHECK_SPT_ITEM_CODE”)
values (SEQ_TBL_LIS_DETAIL3.nextval,
‘2024-08-27 09:22:38.000000’,
‘12130184402051089J’,
‘A160010001577166’,
‘2909676’,
‘35110498’,
‘HGB’,
‘★血红蛋白’,
‘PQ’,
‘139’,
‘g/L’,
‘-’,
‘-’,
‘115–150’,
‘’,
‘-’,
‘1’,
null,
null,
‘2024-08-29 18:06:53.617793’,
‘2024-09-12 04:37:01.372790’,
0,
‘002501010010000’);