Scalar Sub-query: A scalar subquery expression is a subquery that returns exactly one column value from one row. The value of 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.
oracle
Scalar Sub-query: A scalar subquery expression is a subquery that returns exactly one column value from one row. The value of 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.
Subscribe to:
Posts (Atom)
No comments:
Post a Comment