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,

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is vector point function?

0 Answers  

---

What is the best sql course?

0 Answers  

---

how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,

---

What is the use of pl/sql table?

0 Answers  

---

What is nosql db?

0 Answers  

---

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

0 Answers  

---

What does count (*) mean in sql?

0 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

what is difference b/w pravite procedures and public procedures?

3 Answers   Steria, Wipro, Zensar,

---