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 is the difference between sql, mysql and sql server?
Show the two pl/sql cursor exceptions.
What is data type in database?
What is sql scripting?
How do sql databases work?
What is orm in sql?
what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba
What is the difference between delete and truncate statement in sql?
what is the difference between primary key and unique key? : Sql dba
Explain correlated query work?
what is primary key? : Sql dba
How does join work in sql?
how would you get the current date in mysql? : Sql dba
what is the command used to fetch first 5 characters of the string? : Sql dba
What is a temporal table?
