cross

CROSS JOIN LATERAL (
  SELECT
    level AS chunk_num,
    UTL_RAW.CAST_TO_VARCHAR2(
      DBMS_LOB.SUBSTR(
        t.VERSIONS,
        4000,
        (level - 1) * 4000 + 1
      )
    ) AS chunk_content
  FROM dual
  CONNECT BY level <= CEIL(DBMS_LOB.GETLENGTH(t.VERSIONS) / 4000)
) c