Top "Scalar-subquery" questions

A scalar subquery is an SQL subquery used as a scalar expression.

PostgreSQL 9.2 row_to_json() with nested joins

I'm trying to map the results of a query to JSON using the row_to_json() function that was added …

json postgresql postgresql-9.2 scalar-subquery
scalar subquery in if statement Condition in PL/SQL

I have an If Statement block similar to the below which is failing with the error - PLS-00103: Encountered the …

oracle plsql conditional scalar-subquery