Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Subselect in the from clause
As an aside, according to the 9i SQL self test software, you can have an
unlimited number of subqueries.
Tom
www.oraclepower.com
"Tom Dyess" <tdyess_at_dyessindustries.com> wrote in message
news:JEV38.107249$_w.15091919_at_typhoon.tampabay.rr.com...
> What do you mean by the range of use?
>
> The most I've ever done was about 7 or 8 in a single view / query with a
> level of about 4 deep max. Anything more than that probably needs to be
> broken down into summary tables because it will run like a slug with a
> significant amount of data.
>
> Tom
> www.oraclepower.com
>
> "Christian Lang" <clang_at_mediaprint.at> wrote in message
> news:6cf185c9.0201240546.4d05c48e_at_posting.google.com...
> > Hi,
> > who could explain the range of use of a subselect in the from clause.
> >
> > eg.
> >
> > select f1,f2,f3,f4
> > from
> > (select d1,d2,d3,d4 from table)
> > ...
> >
> > thanks
> > Chris
> >
>
>
>
Received on Wed Jan 30 2002 - 14:37:55 CST