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

The error ORA-01427 is raised, when a sub-query returns more than one row to an Equality or in-Equality operator. The reason being there are restrictions on the legal comparison operators.The single row subquery operator are Symbol Meaning = equal > greater than >= greater than or equal < less than <= less than or equal …

ORA-01427: single-row subquery returns more than one row Read More »