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 output spooling in sql*plus?
What are the sql aggregate functions?
How do I write a sql query in pgadmin 4?
what are properties of a transaction? : Sql dba
What is db journal file?
How do you know if a relationship is 2nf?
Explain constraints in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba
How to run pl sql program in mysql?
what is the command used to fetch first 5 characters of the string? : Sql dba
what is not null constraint? : Sql dba
how to drop an existing view in mysql? : Sql dba
what is data integrity? : Sql dba
how to use 'mysql' to run sql statements? : Sql dba
What is the difference between a database and a relational database?