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,

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

What is java sql package?

0 Answers  

---

How do I delete a trigger?

0 Answers  

---

what is commit? : Sql dba

0 Answers  

---

What is scalar and vector?

0 Answers  

---

How do I create a memory optimized filegroup?

0 Answers  

---

What is the maximum number of columns in sql table?

0 Answers  

---

How do I find duplicates in two columns?

0 Answers  

---

What is anonymous block in sql?

0 Answers  

---

What are few of the schema objects that are created using PL/SQL?

0 Answers  

---