Re: outer query

From: Patricio <pecolombo_at_yahoo.com>
Date: 15 Feb 2005 05:15:54 -0800
Message-ID: <32e437a9.0502150515.42478442@posting.google.com>

It's a very strange way Oracle chose to explain sequences.

Basically, it's referring to the outer section of a query that contains subqueries, as in:

select column1,

       column2,
       column3

from table1
where column1 in (select column4,

                         column5
                  from table2
                  where ........)

the query in the where section is an inner query and the main select (select column1, column2, etc) is the outer query.

Hope it helps.

Patricio

vertigo <ax178_at_wp.pl> wrote in message news:<cus8rq$k8e$1_at_atlantis.news.tpi.pl>...
> > Did you mean outer join?
>
> No, i mean outer query.
> Such phrase exists on page:
> http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements6a.htm#4148
>
> but i can not find what exactly it is.
>
> Thanx
> Michal
Received on Tue Feb 15 2005 - 07:15:54 CST