Errors: "ORA-00923" or "ORA-00907" or no rows returned, if select statement includes the 'WITH' sub-clause.
Example 1:
SELECT *
FROM (WITH a AS (SELECT * FROM DUAL)
SELECT *
FROM a)
returns "ORA-00923 - FROM keyword not found where expected"
Example 2:
SELECT * FROM (
WITH
a AS ( SELECT * FROM DUAL )
SELECT * FROM a
)
returns "ORA-00907 - Missing Right Parenthesis"
Example 3:
SELECT * FROM (WITH a AS (SELECT * FROM DUAL) SELECT * FROM a)
runs successfully, but gives no output in grid and spool
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center