Pre-defined Oracle errors are as follows:
i. NO_DATA_FOUND — Refers to an error when a SELECT statement does not return any result set
ii. DUP_VAL_ON_INDEX — Refers to an error when a program tries to store duplicate values in an indexed column
iii. TOO_MANY_ROWS — Refers to an error when a SELECT INTO statement returns more than one row.
iv. VALUE_ERROR — Refers to an error when an arithmetic, conversion, truncation, or size-constraints error occurs
v. ROWTYPE_MISMATCH — Refers to an error when the actual and formal parameters do not have the same data-types.
i. NO_DATA_FOUND — Refers to an error when a SELECT statement does not return any result set
ii. DUP_VAL_ON_INDEX — Refers to an error when a program tries to store duplicate values in an indexed column
iii. TOO_MANY_ROWS — Refers to an error when a SELECT INTO statement returns more than one row.
iv. VALUE_ERROR — Refers to an error when an arithmetic, conversion, truncation, or size-constraints error occurs
v. ROWTYPE_MISMATCH — Refers to an error when the actual and formal parameters do not have the same data-types.