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

DGM-16933: Unable to start instance "string".

1 Answers  


ORA-39093: FLASHBACK automatically enabled to preserve database integrity.

1 Answers  


ORA-32108: max column or parameter size not specified

1 Answers  


ORA-16642: db_unique_name mismatch

1 Answers  


ORA-07254: spdcr: translation error while expanding ?/bin/oracle.

1 Answers  






ORA-24089: AQ Agent string already exists

1 Answers  


ORA-39751: partitioned table on both sides of PARTITIONED OUTER JOIN is not supported

1 Answers  


NZE-28820: Signature or decryption/encryption state is not provided.

1 Answers  


QSM-02023: nested cursor

1 Answers  


ORA-12228: TNS:protocol adapter not loadable

1 Answers  


NZE-28838: no identity descriptor

1 Answers  


ORA-19680: some blocks not recovered. See trace file for details

1 Answers  


Categories