Hello

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


Thanx
Michal

In article <cuqmhd$s2n$1 (AT) atlantis (DOT) news.tpi.pl>, ax178 (AT) wp (DOT) pl enlightened us
with...
Did you mean outer join?
--
--
~kaeli~
Press any key...NO, NO, NO, NOT THAT ONE!!!!!!
http://www.ipwebdesign.net/wildAtHeart
http://www.ipwebdesign.net/kaelisSpace

No, i mean outer query.
Such phrase exists on page:
http://download-west.oracle.com/docs...nts6a.htm#4148

but i can not find what exactly it is.

Thanx
Michal

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 (DOT) pl> wrote

vertigo wrote:

There is no such thing. The phrase is outer join and you can
find information on what they are all over the web ... I would
suggest www.google.com.

For an example of syntax go to http://www.psoug.org
click on Morgan's Library
click on Joins
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)

vertigo wrote:

That is because there is no such thing as an "outer query" ... you
should reread your own link. The phrase is "outer query block" and
it is described quite well in the list of bulleted items that follows.

--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)