Stepwise-Lab

ORA-01427: Single-row subquery returns more than one row

A subquery used with =, <, > or in the SELECT list must return at most one row. Use IN, = ANY or > ALL for several rows, or make the subquery return one row.

On the exam

This error belongs to the topic Subqueries of exam 1Z0-071.

In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.

All Oracle errors