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 are numeric data types? : Sql dba
How to use sql statements in pl/sql?
How to execute a stored procedure?
What is sql prepared statement?
Why we use join in sql?
How many unique keys can a table have?
Is id a reserved word in sql?
Define implicit and explicit cursors.
How long does it take to learn pl sql?
What is the difference between a primary key and a unique key?
What is sql and its types?
How many types of relationship are there?
Why self join is used in sql?
What is the purpose of the sql select top clause?
Explain what is sql?