scalar subqueries

Scalar Subquery: SELECT within SELECT!

A scalar subquery is a single row, single column query, which looks just like a column or function in the SELECT clause. Here’s a look at the unique characteristics and benefits of this feature in Oracle.

Read the Full Article →
Thumbnail image for Correlated Subquery

Correlated Subquery

A correlated subquery is a type of nested subquery that uses columns from the outer query in its WHERE clause. While a simple subquery is evaluated only once for each table, a correlated subquery is evaluated once for each row.

Read the Full Article →
Thumbnail image for Understanding Subqueries and Their Types

Understanding Subqueries and Their Types

A subquery – that is, a query within a query – can be of various flavors in Oracle. Subqueries may be simple or correlated, nested or scalar. A closer look at the types of subqueries and their purpose.

Read the Full Article →