Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: subquery as a table/view for other subqueries in the same complex query ?

Re: subquery as a table/view for other subqueries in the same complex query ?

From: Henry <web_poster03_at_yahoo.com>
Date: 27 Oct 2003 19:35:26 -0800
Message-ID: <b6015d6e.0310271935.262bf0e3@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.
>
> I'm curious.
> Exactly how does someone "compile" a table/view?
Received on Mon Oct 27 2003 - 21:35:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US