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 like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What is sql*loader?

0 Answers  

---

What is a column in a table?

0 Answers  

---

What is the use of cursor ? how cursor allocate context area for executing the sql statement?

4 Answers   HCL,

---

---

What is a cursor for loop ?

4 Answers  

---

how to get a list of all tables in a database? : Sql dba

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

0 Answers  

---

Is progress software supports to ( pl/sql )?

0 Answers  

---

What is mutating sql table?

0 Answers  

---

Does pl/sql support create command?

0 Answers  

---

What do you understand by exception handling in pl/sql?

0 Answers  

---