Explain some predefined exceptions.
Answer / Sapna Arya
In PL/SQL, there are several predefined exceptions that can be raised to handle errors or unexpected conditions. Some examples include NO_DATA_FOUND (when a query does not return any rows), TOO_MANY_ROWS (when more than one row is returned from a function), and ZERO_DIVIDE (when division by zero occurs).
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between delete and truncate commands?
what are the different index configurations a table can have? : Sql dba
what are the limitations of identity column? : Transact sql
select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?
What is Referential Integrity?
What is serial sql?
Can we join same table in sql?
What is t sql used for?
What is an escape character in sql?
What is recursive stored procedure?
how to create a test table in your mysql server? : Sql dba
What are two virtual tables available during database trigger execution ?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)