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



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-12079: materialized view options require COMPATIBLE parameter to be string or greater

1 Answers  


RMAN-06443: error upgrading recovery catalog

1 Answers  


ORA-26514: object 'string.string' not found

1 Answers  


ORA-13349: polygon boundary crosses itself

1 Answers  


RMAN-08116: output filename is original SPFILE location

1 Answers  






ORA-06779: TLI Driver: error reading ccode

1 Answers  


ORA-39307: the operation is illegal without an initial clone

1 Answers  


DRG-50948: ABOUT clause required in the absence of a text index

1 Answers  


SQL*Loader-00700: Out of memory while performing essential allocations [number]

1 Answers  


ORA-25135: cannot use the SINGLE TABLE option

1 Answers  


ORA-02423: schema name does not match schema authorization identifier

1 Answers  


ORA-23375: feature is incompatible with database version at string

1 Answers  


Categories