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,

---

Does varchar need length?

0 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

What is %s in sql?

0 Answers  

---

write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  

---

---

What is pl sql in oracle?

0 Answers  

---

How will you a activate/deactivate integrity constraints?

2 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

What do you mean by rowid?

0 Answers  

---

What is the difference between the repeatable read and serializable isolation levels? : Transact sql

0 Answers  

---

How many postgresql users are there, worldwide?

0 Answers  

---

When we can declare a column as Unique and Not Null both at the same time. What is the use pf Primary Key then?

2 Answers   Accenture, Unisoft Infotech,

---