Answer Posted / hr@tgksolutions.com
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 to get each name only once from an employee table?
How many clustered indexes can you have?
How many types of index are there?
How do sql databases work?
How can I change database name in sql?
Explain the the update statement in sql?
What is duration in sql profiler trace?
what is 'mysqlcheck'? : Sql dba
How do rank () and dense_rank () differ?
What is data control language (dcl)?
Do foreign keys improve performance?
How do you modify a column in sql?
discuss about myisam index statistics collection. : Sql dba
Is primary key clustered or nonclustered?
What does t sql mean?