ORACLE - Questions | Document - Extract and Share

The further the spiritual evolution of mankind advances, the more certain it
seems to me that the path to genuine religiosity does not lie through the
fear of life, and the fear of death, and blind faith, but through striving
after rational knowledge.

— Albert Einstein

ORACLE - Questions

Wed, 11/24/2010 - 21:00 |

Juraj Maslik

Q: What is scalar sub-query expression?
A: Scalar sub-query expression returns exactly one column value.

Q: What is it column?
A: Column is an intersection of row and cell.

Q: Where can be used scalar sub-queries?
A: Scalar sub-queries can be used in

condition and expression part of case|decode.
All clauses of the SELECT statement except for GROUP BY
SET and WHERE clause of UPDATE statement.