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

PCC-00066: Userid only used when SQLCHECK = FULL, userid ignored.

1 Answers

ORA-02217: duplicate storage option specification

1 Answers

ORA-00234: error in identifying or opening snapshot or copy controlfile

1 Answers

NNL-00218: Ignoring spurious trailing text "string"

1 Answers

ORA-13288: point coordinate transformation error

1 Answers

LRM-00106: out of memory

1 Answers

RMAN-06119: uncataloged datafile copy

1 Answers

ORA-04061: existing state of string has been invalidated

1 Answers

DRG-11125: invalid format of existing log file string

1 Answers

ORA-33000: (AGOPEN00) AGGMAP workspace object cannot be accessed because it was compiled by a more recent version of string.

1 Answers

ORA-06511: PL/SQL: cursor already open

1 Answers

LPX-00653: Output attribute '~S' doesn't have a parent element.

1 Answers

For more Oracle Errors Interview Questions Click Here