In table three columns with 1 milion records(here there is no sequence values) i want add one more column with sequence values from the first how it is posible?

4 Answers   Tech Soft,

---

Explain aggregate functions are available there in sql?

0 Answers  

---

Is clustered index a primary key?

0 Answers  

---

What are different clauses used in sql?

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?

4 Answers   KPIT,

---

---

What do you mean by stored procedures? How do we use it?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

How do we use distinct statement? What is its use?

0 Answers  

---

What is use of package in pl sql?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

how to load data with out header and footer records in a database using sql*loader? pls tell me the answer urgently

1 Answers   Oracle, Wipro,

---

What mean sql?

0 Answers  

---