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
Explain how can you save or place your msg in a table?
Can delete statement be rollbacked?
What is cursor explain with example?
How many subqueries can be nested in a statement?
what is a tablespace? : Sql dba
What does inner join mean?
Does inner join return duplicate rows?
What is the difference between a primary key and a clustered index?
How do I count records in sql?
what is the use of set statement in tsql? : Transact sql
What is form and report?
Is microsoft sql free?
what is the difference between where clause and having clause? : Sql dba
Can we join 3 tables in sql?
Is sql a case sensitive language?