17,086
社区成员
发帖
与我相关
我的任务
分享
SELECT T.START_TIME
,NVL(MAX(C.END_TIME) ,T.END_TIME)
FROM (SELECT DISTINCT A.START_TIME,A.END_TIME FROM TEST A
WHERE NOT EXISTS(SELECT 1 FROM TEST B WHERE B.START_TIME < A.START_TIME AND B.END_TIME >= A.START_TIME))T , TEST C
WHERE T.END_TIME >= C.START_TIME(+)
AND T.END_TIME < C.END_TIME(+)
GROUP BY T.START_TIME, T.END_TIME
ORDER BY 1