I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

How do you update a sql procedure?

0 Answers  

---

What is left join in postgresql?

0 Answers  

---

Is microsoft sql free?

0 Answers  

---

Mention what does the hierarchical profiler does?

0 Answers  

---

What is procedure explain with example?

0 Answers  

---

Show the two pl/sql cursor exceptions.

0 Answers  

---

what is global temporary tables and how use that tables in pl/sql packages

1 Answers   Cap Gemini,

---

how do u call in & out parameters for stored procedures?

10 Answers   A1 Technology, TCS, Techicon,

---

Can instead of triggers be used to fire once for each statement on a view?

0 Answers  

---

Can we insert data in view?

0 Answers  

---

Can you call pl/sql package functions from within a fast formula?

0 Answers  

---