oracle 并集 时间_oracle 怎么合并交叉日期

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,