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
What is the purpose of my sql?
What is difference between sql and mysql?
what is 'mysqlshow'? : Sql dba
how to install mysql? : Sql dba
Is primary key an index?
What is basic structure of pl sql?
what are the 'mysql' command line arguments? : Sql dba
what is data manipulation language? : Sql dba
Is not equal in sql?
How can I get the number of records affected by a stored procedure?
what is a composite primary key ? : Sql dba
how to convert dates to character strings? : Sql dba
What is sql dialect?
What is cross join sql?
When is the update_statistics command used?