What is difference between stored procedure and trigger?

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,

---

Which constraints we can use while creating database in sql?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

0 Answers  

---

Difference between aggregate function and analytical function?

3 Answers   Metric Stream,

---

what is the different between unique+not null & primary key,

4 Answers  

---

What is the current version of postgresql?

0 Answers  

---

How do you define a foreign key?

0 Answers  

---

what is the difference between group by and order by in sql? : Sql dba

0 Answers  

---

what is a cursor? : Sql dba

0 Answers  

---

What is dml with example?

0 Answers  

---