Multiple choice technology databases

Where can NOT a subquery be used within a SQL statement that is in a PL/SQL block?

  1. WHERE

  2. FROM

  3. INSERT

  4. UPDATE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In standard PL/SQL and SQL, subqueries can be used in WHERE, INSERT, and UPDATE clauses. While modern SQL allows subqueries in the FROM clause (inline views), older or specific PL/SQL contexts sometimes restricted their use there compared to other clauses.

Keep practicing — related questions