在Oracle SQL中将datetime拆分为多行

SELECT
  TRUNC(sysdate) + (LEVEL - 1) / 24 AS date_part,
  TO_CHAR(TRUNC(sysdate) + (LEVEL - 1) / 24, 'HH24:MI:SS') AS time_part
FROM
  dual
CONNECT BY
  LEVEL <= 24;

DATE_PART           TIME_PART
------------------- --------
2022-01-01 00:00:00 00:00:00
2022-01-01 01:00:00 01:00:00
2022-01-01 02:00:00 02:00:00
...
2022-01-01 22:00:00 22:00:00
2022-01-01 23:00:00 23:00:00