WITH t AS
(
SELECT 'C070' channel_id, '' be_Type, '03:50:00' start_Date, '03:50:00' end_Date FROM dual
UNION ALL SELECT 'C070', '' , '04:12:15', '04:12:15' FROM dual
UNION ALL SELECT 'C070', '' , '04:20:15', '04:20:15' FROM dual
UNION ALL SELECT 'C070', '' , '04:20:29', '04:20:29' FROM dual
UNION ALL SELECT 'C070', '' , '04:25:03', '04:25:03' FROM dual
UNION ALL SELECT 'C070', '' , '04:25:13', '04:25:13' FROM dual
UNION ALL SELECT 'C070', '' , '04:30:00', '04:30:00' FROM dual
UNION ALL SELECT 'C070', 'B', '04:30:31', '04:30:31' FROM dual
UNION ALL SELECT 'C070', 'B', '04:30:47', '04:30:47' FROM dual
UNION ALL SELECT 'C070', 'B', '04:30:59', '04:30:59' FROM dual
UNION ALL SELECT 'C070', '' , '04:31:11', '04:31:11' FROM dual
UNION ALL SELECT 'C070', '' , '04:31:27', '04:31:27' FROM dual
UNION ALL SELECT 'C070', '' , '05:16:33', '05:16:33' FROM dual
UNION ALL SELECT 'C070', '' , '05:24:33', '05:24:33' FROM dual
UNION ALL SELECT 'C070', 'E', '05:24:46', '05:24:46' FROM dual
UNION ALL SELECT 'C070', 'B', '05:29:40', '05:29:40' FROM dual
UNION ALL SELECT 'C070', '' , '05:29:56', '05:29:56' FROM dual
UNION ALL SELECT 'C070', '' , '05:30:00', '05:30:00' FROM dual
UNION ALL SELECT 'C070', '' , '05:30:08', '05:30:08' FROM dual
UNION ALL SELECT 'C070', '' , '05:30:22', '05:30:22' FROM dual
UNION ALL SELECT 'C070', '' , '05:31:37', '05:31:37' FROM dual
UNION ALL SELECT 'C070', '' , '06:18:02', '06:18:02' FROM dual
UNION ALL SELECT 'C070', '' , '06:26:02', '06:26:02' FROM dual
UNION ALL SELECT 'C070', '' , '06:26:10', '06:26:10' FROM dual
UNION ALL SELECT 'C070', '' , '06:28:10', '06:28:10' FROM dual
UNION ALL SELECT 'C070', '' , '06:28:24', '06:28:24' FROM dual
UNION ALL SELECT 'C070', 'E', '06:30:00', '06:30:00' FROM dual
UNION ALL SELECT 'C070', 'B', '06:30:21', '06:30:21' FROM dual
UNION ALL SELECT 'C070', '' , '06:30:37', '06:30:37' FROM dual
UNION ALL SELECT 'C070', '' , '06:31:05', '06:31:05' FROM dual
UNION ALL SELECT 'C070', '' , '06:31:30', '06:31:30' FROM dual
UNION ALL SELECT 'C070', '' , '06:31:45', '06:31:45' FROM dual
UNION ALL SELECT 'C070', '' , '06:59:52', '06:59:52' FROM dual
UNION ALL SELECT 'C070', '' , '07:07:52', '07:07:52' FROM dual
UNION ALL SELECT 'C070', '' , '07:08:17', '07:08:17' FROM dual
UNION ALL SELECT 'C070', 'E', '07:10:00', '07:10:00' FROM dual
UNION ALL SELECT 'C070', 'B', '07:10:14', '07:10:14' FROM dual
UNION ALL SELECT 'C070', '' , '07:10:30', '07:10:30' FROM dual
UNION ALL SELECT 'C070', '' , '07:10:42', '07:10:42' FROM dual
UNION ALL SELECT 'C070', '' , '07:11:01', '07:11:01' FROM dual
UNION ALL SELECT 'C070', '' , '07:12:15', '07:12:15' FROM dual
UNION ALL SELECT 'C070', '' , '08:02:37', '08:02:37' FROM dual
UNION ALL SELECT 'C070', '' , '08:10:37', '08:10:37' FROM dual
UNION ALL SELECT 'C070', '' , '08:10:45', '08:10:45' FROM dual
)
SELECT channel_id
     , ROW_NUMBER() OVER(
       PARTITION BY channel_id ORDER BY MIN(start_Date)) rn
     , MIN(DECODE(be_Type, 'B', start_Date)) start_Date
     , MAX(DECODE(be_Type, 'E',   end_Date))   end_Date
  FROM (SELECT channel_id, be_Type, start_Date, end_Date
             , COUNT(DECODE(be_Type, 'E', 1))
               OVER(PARTITION BY channel_id ORDER BY start_Date DESC) gb
          FROM t
         WHERE be_type IS NOT NULL
        )
 GROUP BY channel_id, gb
HAVING MAX(DECODE(be_Type, 'E',   end_Date)) IS NOT NULL
 ORDER BY channel_id, start_Date
;

우와!!!!!!!!!!!!!!

마농님 너무 너무 감사합니다. 

항상 감사합니다. ^^;