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

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:28:08 CDT