It is a definite error in the manuals. I am not sure but I had thought
that the term scalar subquery had been applied to select statements in
the select list of another query: select col1, (select colb from table
2 ...), col3 when Oracle first introduced it. Subqueries of the form
in the example were just normal subqueries. The definition that
appears in the 9.2 and 10g SQL manual under the topic "Scalar Subquery
Expressions" makes no such distiction. So either the list about where
the scalar subqueries are legal is wrong or the definition of a scalar
subquery requires clarification.
IMHO -- Mark D Powell --
Received on Mon Dec 20 2004 - 08:19:12 CST
