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,

---

Explain what is sql*plus?

0 Answers  

---

How to start oracle sql developer?

0 Answers  

---

Begin For j in 4403201000 .. 4403202000 Loop If mod (j, 100) = 0 then Dbms_output.put_line (j); End if; End loop; End; what will be the output of this question

7 Answers   TCS,

---

What is the starting oracle error number? What is meant by forward declaration in functions?

0 Answers  

---

---

What are the types of views in sql?

0 Answers  

---

what is a foreign key ? : Sql dba

0 Answers  

---

What does plv msg allows you to do?

0 Answers  

---

1.when will you use week refcursor and when will you use strong ref cursor ? 2.what is the use of sql trace..how do you use it ? 3.can you please send all the sql plus commands...like set line 6000....

1 Answers   Satyam,

---

What does pl sql developer do?

0 Answers  

---

What does (+) mean in sql joins?

0 Answers  

---

Which data type doesn't allow null data type?

6 Answers   TCS,

---