Toad World® Forums

With select does not work - ORA-00923


#1

Following query gives

SELECT *
FROM (WITH a AS (SELECT * FROM DUAL)
SELECT *
FROM a)

It gives “ORA-00923 FROM keyword not found where expected”

Spool shows, that only a part of the query is executed:

SELECT *
FROM (WITH a AS (SELECT * FROM DUAL)
SELECT *
==>
ORA-00923: Schlüsselwort FROM nicht an erwarteter Stelle gefunden

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
**** SCRIPT ENDED 31.03.2009 15:09:43 ****
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^


#2

It works if you use

WITH a AS (SELECT * FROM DUAL)
SELECT *
FROM (
SELECT *
FROM a)

but your version should also be working, but it’s not :frowning:


#3

Hi guys,

This CR is still open in our list. We haven’t fixed it yet but it will definitely be included in 6.2.

Gwen


#4

Beta 6.2.0.1381 solves this problem


#5

Thanks for checking it out, Torsten.