CREATE FUNCTION sleep (
  seconds IN NUMBER
) RETURN NUMBER
AS
BEGIN
  DBMS_LOCK.SLEEP( seconds );
  -- In 18c+, use DBMS_SESSION instead, since that package requires less privileges.
  -- DBMS_SESSION.SLEEP( seconds );
  RETURN seconds;
END;
/

然后又道：

SELECT *
FROM   table_name t
       CROSS JOIN
       ( SELECT sleep( 30*60 + 1 ) FROM DUAL ) s;