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
Why we use stored procedure instead of query?
What does bitemporal mean?
What is a rank in sql?
What is the difference between instead of trigger and after trigger?
How does cross join work in sql?
What are inner outer left and right joins in sql?
Can we use insert statement in function?
What is the largest value that can be stored in a byte data field?
what is a composite key ? : Sql dba
What is the difference between python and sql?
What is the sql case statement?
how can we know the number of days between two given dates using mysql? : Sql dba
What is nosql vs sql?
Is left join inner or outer?
Explain the uses of database trigger.