what is difference between procedure and function, procedure and trigger?

8 Answers   iFlex,

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

What will you get by the cursor attribute sql%rowcount?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

What is trigger explain with example?

0 Answers  

---

Does postgresql run on the cloud?

0 Answers  

---

what is heap table? : Sql dba

0 Answers  

---

what is a primary key? : Sql dba

0 Answers  

---

What are the different ways to optimize a sql query?

0 Answers  

---

What are database links used for?

0 Answers  

---

Which join is like an inner join?

0 Answers  

---