Multiple choice

What operator is used to prevent the error: 'ORA-01427:single row sub query returns more than one row'?

  1. Use the IN operator

  2. Use the >= operator

  3. Use the CAN EXIST operator

  4. Use the = operator
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The ORA-01427 error occurs when a subquery that should return only one row returns multiple rows. The IN operator is designed to handle multiple values and eliminates this error by checking if a value exists in the result set rather than requiring equality with a single row.

Keep practicing — related questions