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
Is ms sql traffic encrypted?
What is parameter substitution in sql?
What is oracle pl sql developer?
who introduced sql?
What is the maximum number of triggers, you can apply on a single table?
Explain isolation levels. : Transact sql
Name some usages of database trigger?
Do ddl statements need commit?
Is it possible for a table to have more than one foreign key?
Is the primary key an index?
What are local and global Indexes and where they are useful.
What is substitution variable in pl sql?
What is a parameter query?
Is it important to partition hard disk?
What are the parts of a basic sql query?