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,

---

What are the disadvantages of file system?

0 Answers  

---

how will be date change into string

4 Answers  

---

What is dml statement?

0 Answers  

---

Can we rollback truncate?

0 Answers  

---

---

i have a table with column sno with 30 records. i want to update this column by item by item in asp.net. i wantto enter new values into that from 1 to 30 how is it possible with backend c#

1 Answers  

---

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What are the advantages of sql?

0 Answers  

---

What is primary key in db?

0 Answers  

---

How to test for null values?

0 Answers  

---

How do I partition in sql?

0 Answers  

---