WITH t1 AS (
	SELECT 1  AS PK, NULL AS PARENT_ID, 100 AS ID FROM dual  UNION ALL --начало истории другого документа
	SELECT 2  AS PK, NULL AS PARENT_ID, 283 AS ID FROM dual  UNION ALL
	SELECT 3  AS PK, NULL AS PARENT_ID, 284 AS ID FROM dual  UNION ALL
	SELECT 4  AS PK, NULL AS PARENT_ID, 231 AS ID FROM dual  UNION ALL
	SELECT 5  AS PK, 283  AS PARENT_ID, 245 AS ID FROM dual  UNION ALL
	SELECT 6  AS PK, 284  AS PARENT_ID, 245 AS ID FROM dual  UNION ALL
	SELECT 7  AS PK, 231  AS PARENT_ID, 247 AS ID FROM dual  UNION ALL
	SELECT 8  AS PK, 100  AS PARENT_ID, 101 AS ID FROM dual  UNION ALL  --продолжение истории другого документа
	SELECT 9  AS PK, 245  AS PARENT_ID, 264 AS ID FROM dual  UNION ALL
	SELECT 10 AS PK, 245  AS PARENT_ID, 265 AS ID FROM dual  UNION ALL
	SELECT 11 AS PK, 247  AS PARENT_ID, 265 AS ID FROM dual  UNION ALL
	SELECT 12 AS PK, 247  AS PARENT_ID, 273 AS ID FROM dual  UNION ALL
	SELECT 13 AS PK, 264  AS PARENT_ID, 252 AS ID FROM dual
)
select ID
from dual;
/

WITH
numbers ( n ) AS (
   SELECT 1 AS n
   FROM dual -- исходное множество -- одна строка
  	UNION ALL                      -- символическое «объединение» строк
   SELECT n + 1 AS n               -- рекурсия: добавок к предыдущему результату
   FROM   numbers                  -- предыдущий результат в качестве источника данных
    WHERE  n < 5                   -- если не ограничить, будет бесконечная рекурсия
)
SELECT n
FROM numbers             		   -- основной запрос
;

WITH
  anchor1234 ( n ) AS (             -- обычный
     SELECT 1 FROM dual UNION ALL
     SELECT 2 FROM dual UNION ALL
     SELECT 3 FROM dual UNION ALL
     SELECT 4 FROM dual
  )
, numbers ( n ) AS (                -- рекурсивный
     SELECT n FROM anchor1234
        UNION ALL
     SELECT n + 1 AS n
     FROM   numbers
     WHERE n < 5
  )
SELECT n FROM numbers
;
/