what is difference between procedure and function

10 Answers   MCN Solutions, Wipro,

---

What is the command used to fetch first 5 characters of the string?

0 Answers  

---

Does normalization improve performance?

0 Answers  

---

will function return more than one value how

9 Answers   Accenture,

---

Types of locks in database ?

8 Answers   HCL, TCS, Tieto,

---

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,

---

What are the benefits of using PL/SQL packages?

3 Answers  

---

difference between anonymous blocks and sub-programs.

0 Answers  

---

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

---

how is exception handling handled in mysql? : Sql dba

0 Answers  

---

HOW TO TUNE ORACLE SQL QUERIES GIVE ME STEP BY SREP

1 Answers   TCS,

---

What is sql*loader?

0 Answers  

---