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
what are the differences among rownum, rank and dense_rank? : Sql dba
how to see the create table statement of an existing table? : Sql dba
which operator is used in query for pattern matching? : Sql dba
how to concatenate two character strings? : Sql dba
how can we know the number of days between two given dates using mysql? : Sql dba
Explian rowid, rownum?
What is t-sql? : Transact sql
what is timestamp in mysql? : Sql dba
Explain the advantages and disadvantages of stored procedure?
What is Difference Between Unique and Primary Key Constraints?
What is data abstraction in sql?
How does postgresql compare to "nosql"?
what is a database? : Sql dba
Which query operators in sql is used for pattern matching?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?