Answer / tulsi

Exception is the error handling part of PL/SQL block. The
types are Predefined and user_defined. Some of Predefined
execptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.

Answer / chintu

Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
Predefined exceptions are
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

Which is faster union or join?

0 Answers  

---

What is the usage of NVL?

7 Answers   Infosys, Micro Infotek,

---

Does google use sql?

0 Answers  

---

what is the difference between delete and truncate statement in sql? : Sql dba

0 Answers  

---

---

What is indexes?

0 Answers  

---

What is rank dense_rank and partition in sql?

0 Answers  

---

What are triggers and its types?

0 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

what is the difference between trigger and constraint?

3 Answers   HSBC,

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

0 Answers  

---

How many row comparison operators are used while working with a subquery?

0 Answers  

---