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
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center