SQL-02112: SELECT..INTO returns too many rows

Question Posted / guest

SQL-02112: SELECT..INTO returns too many rows..

Answer / guest

Cause: A SELECT...INTO statement returned more rows than can
be stored in the host variable provided.

Is This Answer Correct ?

14 Yes

4 No

More Oracle Errors Interview Questions

ORA-29805: missing COLUMN keyword

LPX-00320: No more attributes can be added to a non empty element

ORA-23537: function or procedure string is not allowed to be invoked from this site.

ORA-01061: cannot start up a V8 server using a V7 client application

ORA-14052: partition-extended table name syntax is disallowed in this context

ORA-14636: only 2 resulting subpartition can be specified for SPLIT SUBPARTITION

ORA-38955: Source platform string not cross platform compliant

NNL-00991: Maximum number of reforwards per request: number

ORA-37076: (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT and NTEXT.

ORA-09218: sfrfs: failed to refresh file size

RMAN-06706: could not close file: "string" (reason=string)

NNO-00623: setting auto-refresh retry interval to number seconds

For more Oracle Errors Interview Questions Click Here