Answer Posted / nashiinformaticssolutions
Predefined exceptions in PL/SQL include:
• NO_DATA_FOUND: Raised when a SELECT statement returns no rows.
• TOO_MANY_ROWS: Raised when a SELECT INTO statement retrieves multiple rows.
• DUP_VAL_ON_INDEX: Raised when attempting to insert a duplicate value into a specific index.
• ZERO_DIVIDE: Raised when dividing by zero.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of constraints?
What is t sql in sql server?
What are tables and fields in the database?
Is postgresql a server?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Can we change the table name in sql?
What is dense_rank in sql?
what's the difference between a primary key and a unique key? : Sql dba
How is data stored in sql?
How to connect a sql*plus session to an oracle server?
What normalization means?
What is microsoft t sql?
What are the different dml commands in sql?
How can triggers be used for the table auditing?
What is a design view?