Skip to Main Content

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!

WITH xx AS structure

1006212May 14 2013 — edited May 14 2013
Hello all
we have this structure

WITH xx AS

which makes a temporary table for us,
now imagine we use it after that in select command.
and is it also possible to use it again in select command?

because i used with xx as and then i had 2 select and just for the last select i had error indicating this view or table doesn't exist.

thank you for ur advice

oragle 11g

best,
david
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2013
Added on May 14 2013
10 comments
916 views