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

Options
- Use the IN operator
- Use the >= operator
- Use the CAN EXIST operator
- Use the = operator

CORRECT ANSWER : Use the IN operator

Discussion Board
Training

Hi ,
Greetings from Application Plus Technologies !!
We are providing training with certification for the below skill set ,
*Oracle SQL
* Advance SQL
*PLSQL
*Advance PLSQL
* EBS Technical
* Fusion technical
If you are looking for training contact us
WhatsApp No : 8108735227 / 7499992939
Official Email : nida.k@applplus .com

Nida Khan 03-26-2022 03:04 AM

IN Operator

IN operator is used to prevent the error: ‘ORA-01427:single row sub query returns more than one row’. IN operator is used to specify which values to compare or reword the query so only one row is retrieved.

Prajakta Pandit 02-2-2017 06:13 AM

in operator

Allow you to select multiple row. Equivalent for many or statement

mindhead 04-7-2015 11:50 AM

Getting knowledge

I want to learn more about oracle

upendra 11-28-2014 12:44 PM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲