ORA-01422: exact fetch returns more than requested number of rows

ORA-01422: exact fetch returns more than requested number of
rows

Question Posted / guest

1 Answers
5659 Views
I also Faced
E-Mail Answers

ORA-01422: exact fetch returns more than requested number of rows..

Answer / guest

Cause: The number specified in exact fetch is less than the
rows returned.

Action: Rewrite the query or change number of rows requested

Please add more information about this Error

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More Oracle Errors Interview Questions

ORA-14509: specified VALIDATE INTO table form incorrect

1 Answers

IMG-02002: 2FF02 - incorrect average color feature specification

1 Answers

ORA-30572: AUTO segment space management not valid with DICTIONARY extent management

1 Answers

ORA-15198: operation string is not yet available

1 Answers

DRG-50703: listener startup error

1 Answers

SQL*Loader-00955: Error calling col array build, block formatter

1 Answers

RMAN-06176: no recovery required; all files are readonly or offline

1 Answers

ORA-27501: IPC error creating a port

1 Answers

RMAN-06115: changed backup piece available

1 Answers

ORA-25450: error string during evaluation of rule set string.string

1 Answers

PLS-00120: inappropriate argument in OPEN statement

1 Answers

ORA-27209: syntax error in device PARMS - unknown keyword or missing =

1 Answers

For more Oracle Errors Interview Questions Click Here