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
Is sql database free?
What is the use of procedures?
Can we use distinct and group by together?
Is sqlexception checked or unchecked?
What is a crud api?
What is the usage of nvl function?
What is the difference between partition and index?
What is the difference between left join and right join?
How to pronounce postgresql?
Which constraints we can use while creating database in sql?
What does seeding a database mean?
how many ways to get the current time? : Sql dba
How to prepare for oracle pl sql certification?
Can we edit a view in sql?
Can I call a procedure inside a function?