Answer / highness

you can pass the value back to the user

by using the OUT parameter;

but mostly function is used to return only one value..

its like to compute the task and to return a value;

?? but in this case why dont u opt for a procedure, since its

designed to handle this type of situations...

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Is a foreign key always unique?

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

how to increment dates by 1 in mysql? : Sql dba

0 Answers  

---

How do you declare a constant?

0 Answers  

---

What is pl sql commands?

0 Answers  

---

What is varchar example?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

How do I partition a table in sql?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

What is sql used for?

0 Answers  

---

Can you have more than one trigger on a table?

0 Answers  

---