1

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?

1
  • 1
    Check this stackoverflow.com/a/44765892/836215 . You can simulate functionality of pseudo column LEVEL. Or you can use setQueryTimeout() in JDBC. It is part of standart JDBC 4.2 and is implemented by Oracle's drivers.
    – ibre5041
    Commented Jun 18, 2023 at 11:24

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.