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 is data stored on a disk?
Does sql profiler affect performance?
Can you inner join the same table?
How can a pl sql block be executed?
What is substitution variable in pl sql?
Is primary key is clustered index?
Why having clause is used in sql?
What is input buffer in sql*plus?
What is scalar function?
Why do we need pl sql?
What is sql profiler in oracle?
Why use truncate instead of delete?
Explian rowid, rownum?
What do you mean by query optimization?
How we can update the view?