Answer Posted / glibwaresoftsolutions
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
How can you view the errors encountered in a trigger?
How to change the order of columns in Oracle SQL Plus ?
Can primary key be changed?
Does execute immediate commit?
What is the usage of nvl function?
What is a behavioral trigger?
How can check sql version from command line?
Why is %isopen always false for an implicit cursor?
Does varchar need length?
What is the difference between inner join and natural join?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
What are the most important characteristics of pl/sql?
What are the different parts of a package?
how do you know if your mysql server is alive? : Sql dba
How to select 10 records from a table?
