outer query

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

vertigo wrote:

DA Morgan · *nix forums Guru Joined: 06 Mar 2005 Posts: 1042

vertigo wrote:

Patricio · *nix forums beginner Joined: 15 Feb 2005 Posts: 2

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@wp.pl> wrote in message news:<cus8rq$k8e$1@atlantis.news.tpi.pl>...

vertigo · *nix forums addict Joined: 23 Mar 2005 Posts: 71

kaeli · *nix forums beginner Joined: 14 Feb 2005 Posts: 1

In article <cuqmhd$s2n$1@atlantis.news.tpi.pl>, ax178@wp.pl enlightened us
with...

vertigo · *nix forums addict Joined: 23 Mar 2005 Posts: 71

Hello

What is 'outer query' ? Could anybody give any example ?

Thanx
Michal

Google