Answer Posted / nashiinformaticssolutions
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
Can sql function call stored procedure?
describe mysql connection using mysql binary. : Sql dba
What are different types of indexes?
What is trigger point?
What is indexes?
What is data profiling in sql?
What does the hierarchical profiler does?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is data types in sql?
Are dml statements autocommit?
What are the features of pl sql?
Explain locks? : Transact sql
What is the difference between database trigger and stored procedure?
what are the differences between char and nchar? : Sql dba
Show the two pl/sql cursor exceptions.