Answer / rajesh venati

Yes, we can use global variables in procedure and functions.

Is stored procedure faster than query?

0 Answers  

---

What is Histogram?

0 Answers   NIIT,

---

why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba

0 Answers  

---

how to use case expression? : Sql dba

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

0 Answers  

---

Difference between views and materialized views?

5 Answers   BirlaSoft,

---

What is NOCOPY?

6 Answers   DELL,

---

What is the difference between join and natural join?

0 Answers  

---