What are the modes of parameters that can be passed to a procedure ?

3 Answers  

---

how to achieve this problem?i am having table with two colums like empno,gender. in gender column, i am having records male,female like that .my final output will be male female 5 6

4 Answers   Hexaware,

---

What is trigger explain it?

0 Answers  

---

Can a trigger call a stored procedure?

0 Answers  

---

Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?

3 Answers   eBay,

---

Define sql delete statement.

0 Answers  

---

How do I know if I have sql express or standard?

0 Answers  

---

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

---

Is there any problem if we use commit repeatedly after each dml statement in a plsq procedure ? (eg. there are 10 update stmt and using 10 commit stmt after each update stmt)

1 Answers  

---

What are system versioned tables?

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

What are sql functions? Describe the different types of sql functions?

0 Answers  

---