Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: subquery as a table/view for other subqueries in the same complex query ?
web_poster03_at_yahoo.com (Henry) wrote in message news:<b6015d6e.0310271935.262bf0e3_at_posting.google.com>...
> how to do it correctly? could you give an example? Thanks
>
>
> "Anna C. Dent" <anacdent_at_hotmail.com> wrote in message news:<iMgnb.86842$Ms2.76926_at_fed1read03>...
> > Henry wrote:
> >
> > > If a complext have (say) 6 subqueries, I tried to make one as a
> > > table/view for other subqueries in a complex query. I assume this will
> > > avoid to query the same information for several times. But when
> > > compling, it complains it can not find the table/view.
> > >
> > > Is it possible to use it this way?
> >
> > Yes, if done correctly.
You'll find examples and correct systax in the manuals.
I could give an example, but you need to do your own homework. Received on Tue Oct 28 2003 - 13:05:46 CST