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.

What is a rank in sql?

897

---

Can procedure in package be overloaded?

1028

---

Is sql a backend?

966

---

what is normalization? : Sql dba

1014

---

What is sql query limit?

905

---

What is PL/SQL Records?

1112

---

What is oracle pl sql developer?

931

---

What is the use of desc in sql?

913

---

What is nosql vs sql?

1119

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7130

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

944

---

How do you truncate?

851

---

Why is sql important?

1021

---

What is package in pl sql with an examples?

967

---

Why use subqueries instead of joins?

1028

---