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 a join?
How do I find duplicates in sql?
What is the difference between null value, zero, and blank space?
What is number function in sql?
Is not null in sql?
Which data type is a composite type?
How many primary keys can a table have?
What is the difference between a procedure and a function?
What is correlated sub-query?
there is A table and B table in A table there 5 rows and in b table there are 2 rows i am firing query select * from a,b what will be the output?
How do rank () and dense_rank () differ?
What are the types of functions in 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)