What are pl/sql exceptions? Tell me any three.
Answer / kiran r
An Exception is error handling part when ever error occurs exception raises.
Exceptions are classified as
1. Predefined Exception
2.User defined exception
some of predefined Exceptions are:
NO DATA FOUND, TOO MANY ROWS, CURSOR ALREADY OPEN, INVALID CURSOR, INVALID NUMBER, ZERO DIVIDED
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the difference between clustered and non-clustered indexes?
What is the difference between rollback and rollback to statements?
What are the types pl/sql code blocks?
what are the 'mysql' command line arguments? : Sql dba
What is the difference between local and global temporary table?
What are the differences between implicit and explicit cursors?
What is autocommit sql?
What are the operators in sql?
What are the types of join and explain each?
What is the plv (pl/vision) package offers?
which tcp/ip port does sql server run on? : Sql dba
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Oracle (3259)
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)