what is the difference between nested subquery and correlated subquery?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

what is Difference between Having and Where clause?

5 Answers   IBM,

---

What are the cursor attributes used in PL/SQL ?

4 Answers  

---

how to convert dates to character strings? : Sql dba

0 Answers  

---

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

---

How do you update f as m and m as f from the below table testtable?

0 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  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

What is meant by cursor in sql?

0 Answers  

---

What is sql and db2?

0 Answers  

---

What is the difference between inner join and left join?

0 Answers  

---