Re: SELECT col_a, (SELECT col_b .....

Hi Spencer,

I agree with you...I noticed after i posted that the example wasn't the regular inline view (in the FROM clause)...I apologize to all if I mislead anybody....it seems to me that this would just result in a value placed into every record, but I haven't ever used it either....

Thanks to all for holding their fire :)

Spencer wrote:

> i've not used that particular construct before, that is, using a select
> statement in the select list...
>
> i refer to an imbedded select statement as an "inline view", but have only
> used this construct in the FROM clause of another select...
>
> HTH
>
> "Frank" <franjoe_at_frisurf.no> wrote in message
> news:%ED07.2768$Jp5.46360_at_news1.oke.nextra.no...
> > Hi!
> > Oracle 8.1.6/Windows2000
> >
> > I have found that Oracle now handles queries with the form:
> > SELECT col_a,
> > (SELECT col_b FROM table_b WHERE find only one row)
> > FROM table_a a
> > WHERE find stuff;
> >
> > What is this construction called ? (so I can search for it in the
> > documentation)
> > How does Orcale optimize this ?
> > It seems to me that a expression like this could be rewritten to a "old"
> > query like:
> > SELECT col_a, col_b
> > FROM table_a a, table_b
> > WHERE a.id=b.id(+);
> >
> > Is that happening behind the scenery?
> >
> > Frank
> >
> >
> >
> >
> >
  Received on Sat Jul 21 2001 - 16:29:07 CDT