create a store procedure and created synonms for that store procedure after modify that store procedure will effect on synonms? If we delete the store procedure what happened to that synonms?

2 Answers   Polaris,

---

Can triggers stop a dml statement from executing on a table?

0 Answers  

---

What is the difference between anonymous block and named blocks?

3 Answers  

---

What is the difference between subquery and correlated query?

0 Answers  

---

explain the difference between delete , truncate and drop commands? : Sql dba

0 Answers  

---

What is the use of prepared statement?

0 Answers  

---

What does plv msg allows you to do?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

Fetch an entire row from the employees table for a specific employee ID:

2 Answers  

---

What is package in pl sql?

0 Answers  

---

How do you remove duplicate records from a table?

0 Answers  

---

what is the difference between myisam static and myisam dynamic? : Sql dba

0 Answers  

---