What is the difference between syntax error and runtime error?

0 Answers  

---

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 do we need to check in database testing?

0 Answers  

---

How to rename a column in the output of sql query?

0 Answers  

---

How do you sort in sql?

0 Answers  

---

Explain the difference between drop and truncate commands in sql?

0 Answers  

---

what is the difernece between named and anonymous pl/sql blocks??

8 Answers   TCS, Wells Fargo,

---

how many triggers are allowed in mysql table? : Sql dba

0 Answers  

---

Explain the update statement in sql

0 Answers  

---

What are the ddl commands?

0 Answers  

---

How can one get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---