Answer Posted / suresh kumar somayajula

Raising an error in PL/SQL execution block is nothing
but "Execption". These are of 2 types.
1.Predefined Exception 2. User defined Exception

Total 19+1 predefined exceptions are there.
19+1 means 19+When Others.
"When others" is the last one.After "When Others" no
exception will be raised.
Eg. for Predefined Exceptions:
No_data_found,Dup_val_on_index,Invalid_cursor,Invalid_number
,Zero_Divide,.......,'When Others'..

Thank you,
Suresh.

Why trigger is used in sql?

1015

---

What is the default isolation level in sql server? : Transact sql

1080

---

Can we debug stored procedure?

1063

---

What are views in sql?

1036

---

What is procedure and function in sql?

1045

---

What is clustered and nonclustered index in sql?

985

---

Can we delete column in sql?

1171

---

What is a left join?

1006

---

What is the difference between explicit and implicit cursors in oracle?

1111

---

How to change the order of columns in Oracle SQL Plus ?

1101

---

What is a parameter query?

1141

---

What is primary key sql?

1107

---

What are the two virtual tables available at the time of database trigger execution?

1270

---

What is clustered index sql?

1030

---

how to use in conditions? : Sql dba

1058

---