在Oracle SQL中，如何将持续时间拆分为每小时间隔？

CREATE TABLE duration_table (
  start_time TIMESTAMP,
  end_time TIMESTAMP
);

SELECT 
  start_time,
  end_time,
  EXTRACT(HOUR FROM (end_time - start_time)) AS duration_hours,
  EXTRACT(MINUTE FROM (end_time - start_time)) AS duration_minutes,
  EXTRACT(SECOND FROM (end_time - start_time)) AS duration_seconds
FROM duration_table;

WITH duration_intervals AS (
  SELECT 
    start_time,
    end_time,
    EXTRACT(HOUR FROM (end_time - start_time)) AS duration_hours,
    EXTRACT(MINUTE FROM (end_time - start_time)) AS duration_minutes,
    EXTRACT(SECOND FROM (end_time - start_time)) AS duration_seconds
  FROM duration_table
)
SELECT 
  start_time,
  end_time,
  duration_hours,
  duration_minutes,
  duration_seconds,
  (duration_hours * 60 + duration_minutes + duration_seconds / 60) AS duration_in_minutes
FROM duration_intervals;