Give A Few Pre-defined Oracle Errors ?

1.	Give A Few Pre-defined Oracle Errors ?
Answer» Pre-defined Oracle ERRORS are as FOLLOWS: NO_DATA_FOUND —Refers to an ERROR when a SELECT statement does not return any result set. DUP_VAL_ON_INDEX —Refers to an error when a program TRIES to store duplicate values in an indexed COLUMN. TOO_MANY_ROWS —Refers to an error when a SELECT INTO statement returns more than one row. *VALUE_ERROR* —Refers to an error when an arithmetic, conversion, truncation, or size-constraints error occurs. ROWTYPE_MISMATCH —Refers to an error when the actual and formal parameters do not have the same datatypes Pre-defined Oracle errors are as follows:

Answer»

Pre-defined Oracle ERRORS are as FOLLOWS:

NO_DATA_FOUND —Refers to an ERROR when a SELECT statement does not return any result set.
DUP_VAL_ON_INDEX —Refers to an error when a program TRIES to store duplicate values in an indexed COLUMN.
TOO_MANY_ROWS —Refers to an error when a SELECT INTO statement returns more than one row.
VALUE_ERROR —Refers to an error when an arithmetic, conversion, truncation, or size-constraints error occurs.
ROWTYPE_MISMATCH —Refers to an error when the actual and formal parameters do not have the same datatypes

Pre-defined Oracle errors are as follows:

Discussion