博客内容讲述了如何在Oracle数据库中处理具有交叉日期的记录。创建了一个名为AA_TEST的表，包含主键ID（PID）、起始日（EF）和失效日（ET）三个字段，并插入了多个具有交叉日期的记录。问题在于如何合并那些主键相同且日期存在交叉的记录。
createtableAA_TEST(PIDNUMBER,EFNUMBER,ETNUMBER);commentoncolumnaa_test.PIDis'主键ID';commentoncolumnaa_test.EFis'起始日';commentoncolumnaa_test.ETis'失效日';insertintoAA_...
create table AA_TEST
(
PID NUMBER,
EF NUMBER,
ET NUMBER
)
;
comment on column aa_test.PID is '主键ID';
comment on column aa_test.EF is '起始日';
comment on column aa_test.ET is '失效日';
insert into AA_TEST (PID, EF, ET)
values (1, 20040501, 20040511);
insert into AA_TEST (PID, EF, ET)
values (1, 20040504, 20040505);
insert into AA_TEST (PID, EF, ET)
values (1, 20040508, 20040608);
insert into AA_TEST (PID, EF, ET)
values (1, 20040101, 20040321);
insert into AA_TEST (PID, EF, ET)
values (1, 20030101, 20030227);
insert into AA_TEST (PID, EF, ET)
values (1, 20030227, 20030427);
insert into AA_TEST (PID, EF, ET)
values (1, 20030527, 20030627);
insert into AA_TEST (PID, EF, ET)
values (1, 20030603, 20030923);
insert into AA_TEST (PID, EF, ET)
values (1, 20030929, 20031129);
insert into AA_TEST (PID, EF, ET)
values (1, 20031020, 20031025);
insert into AA_TEST (PID, EF, ET)
values (1, 20040405, 20040513);
commit;
--问题：将此表中同一主键ID对应记录EF和ET日期时间段存在交叉的记录合并成一条，如不存在交叉记录则保留。
展开
扫一扫
1102
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
