Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Expressions, 11 of 14
A scalar subquery expression is a subquery that returns exactly one column value from one row. The value of the scalar subquery expression is the value of the select list item of the subquery. If the subquery returns 0 rows, then the value of the scalar subquery expression is NULL
. If the subquery returns more than one row, then Oracle returns an error.
You can use a scalar subquery expression in most syntax that calls for an expression (expr
). However, scalar subqueries are not valid expressions in the following places:
RETURNING
clause of DML statements
CHECK
constraints
WHEN
conditions of CASE
expressions
GROUP
BY
and HAVING
clauses
START
WITH
and CONNECT
BY
clauses
CREATE
PROFILE
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|