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 are primary key and foreign key and how they work?
please explain database architecture..
what is foreign key? : Sql dba
How to check if a column is nullable before setting to nullable?
what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...
Can two tables have same primary key?
What do you mean by field in sql?
what is a foreign key ? : Sql dba
Which data type is a composite type?
I m giving Source, Destination and Age. Write a procedure or function, it will give to u this source to destination tickets are available or not, if available then check this person is senior citizen or not,if this person is senior citizen then give some discount. PLZ give this answer...... Thanks advance.....
What is raid? How does it help storage of databases?
what are the advantages of cursors than procedures?
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)