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
what is query cache in mysql? : Sql dba
What is difference between stored procedure and trigger?
what is the difference between delete and truncate commands? : Sql dba
how to select unique records from a table? : Sql dba
Why query optimization is needed?
Sql technical questions
Can a commit statement be executed as part of a trigger?
What is the purpose of a secondary key?
Explain normalization and what are the advantages of it?
Which normal form is best?
What are the two virtual tables available at the time of database trigger execution?
Is sqlite good enough for production?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
Can we insert data in view?
What is sqlerrd?