In a DBMS like Microsoft SQL, there is a default limit of 100 recursions, in a recursive CTE, which can be adjusted with:
WITH cte AS (
…
)
SELECT * FROM cte OPTION (MAXRECURSION …);
As far as I can tell, in PostgreSSQL, MariaDB and MySQL, you need to set a timeout.
Is there an option either for the number of recursions or a timeout for Oracle?