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
5658 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-01715: UNIQUE may not be used with a cluster index

1 Answers

LSX-00118: fixed facet value cannot be changed

1 Answers

ORA-08210: Requested I/O error

1 Answers

DRG-11224: Third-party filter is unable to create or write to temporary file.

1 Answers

ORA-02324: more than one column in the SELECT list of THE subquery

1 Answers

DRG-11222: Third-party filter does not support this known document format.

1 Answers

IMG-00523: invalid process verb

1 Answers

RMAN-06034: at least 1 channel must be allocated to execute this command

1 Answers

TNS-00282: Connection Manager: Failed to force log, logging is off

1 Answers

ORA-12001: cannot create log: table 'string' already has a trigger

1 Answers

NNC-00425: meta-data violation

1 Answers

ORA-23387: replication parallel push dequeue error

1 Answers

For more Oracle Errors Interview Questions Click Here