SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Invalid identifier and 'WITH clause' syntax

496797Jun 20 2006 — edited Jun 20 2006

I am receiving 'invalid identifier' errors in a number of cases using the WITH clause, the most distilled case possibly being this..

WITH 
	x AS (SELECT * FROM dual),
	y AS (SELECT * FROM dual) 
SELECT * 
FROM y 
WHERE y.dummy = x.dummy;

...but showing up in other cases as well (with a single WITH in an outer query being referenced in an nested query, for example).

So far as I am aware that is correct syntax and usage.

I note mention of issues with WITH in earlier 9.2.0.x releases but some suggestion that most had been resolved by 9.2.0.5 (the version I am running against currently). Does anyone have any insight into the errors, or is there an error is the syntax of the posted query?

Many thanks,
Mark

Message was edited by: MJH
- Changing title to something more generally useful

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2006

Added on Jun 20 2006

1 comment

1,518 views