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
Is sql pronounced sequel or sql?
Can we call stored procedure in function?
How to know the last executed procedure?
Why is the cursor important?
How to install oracle sql developer?
Can you join a table to itself?
How to get each name only once from an employee table?
What are the disadvantages of not performing database normalization?
What are the datatypes available in pl/sql ?
What is dba in sql? : SQL DBA
What is a sql driver?
How do I turn a list into a table?
What is database migration?
how to see the create table statement of an existing table? : Sql dba
What is a loop in sql?