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
5721 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

DRG-11524: primary key value is missing

1 Answers

ORA-08315: sllfrb: Error reading file

1 Answers

ORA-32114: Cannot perform operation on a null LOB

1 Answers

DRG-11847: Revalidation Failed

1 Answers

DRG-11304: function-based indexes are not supported by this indextype

1 Answers

ORA-19734: wrong creation SCN - control file expects converted plugged-in datafile

1 Answers

TNS-12542: TNS:address already in use

1 Answers

ORA-07485: scg_get_inst: cannot open instance number lock.

1 Answers

LPX-00112: element "~S" has multiple ID attributes

1 Answers

SQL*Loader-00903: Database must be at least version number.number.number.number.number for direct path

1 Answers

ORA-06766: TLI Driver: close failed during release

1 Answers

RMAN-06454: duplexed backups require Enterprise Edition

1 Answers

For more Oracle Errors Interview Questions Click Here