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.

Difference between table function and pipelined function?

1003

---

Can we use ddl statements in stored procedure?

1130

---

What is anonymous block in sql?

1108

---

What are crud methods?

1015

---

Can a table contain multiple foreign key’s?

983

---

Can a table have no primary key?

1038

---

Is coalesce faster than isnull?

954

---

What are the different sql commands?

1053

---

How do you pronounce sql?

988

---

Does a user_objects view have an entry for a trigger?

1000

---

What are the query optimization techniques?

914

---

What are the types of queries in sql?

1065

---

Explain what is rdbms?

1018

---

Is left join inner or outer?

1003

---

Can I call a procedure inside a function?

986

---