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 the difference between a primary key and a clustered index?

989

---

What is asqueryable?

965

---

What is oracle pl sql developer?

979

---

What is constant in pl sql?

1020

---

Explain isolation levels. : Transact sql

1068

---

What is the difference between microsoft sql and mysql?

960

---

What is case function?

1040

---

What are tables in sql?

1061

---

How do I sort a table in sql?

1042

---

Give the order of sql select?

1133

---

What version is sql?

1026

---

What is the use of count (*) in sql?

1051

---

What is scalar function in sql?

1038

---

Define SQL and state the differences between SQL and other conventional programming Languages?

1210

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

956

---