How can a function retun more than one value in oracle with proper example?

1 Answers  

---

How many subqueries can be nested in a statement?

1 Answers  

---

What is user defined functions?

1 Answers  

---

How do I count duplicates in sql?

1 Answers  

---

Does truncate require commit?

1 Answers  

---

Is pl sql a scripting language?

1 Answers  

---

What is range partitioning?

1 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

1 Answers  

---

Can we join two tables without common column?

1 Answers  

---

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---

what are the join types in tsql? : Transact sql

1 Answers  

---

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?

2 Answers  

---