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,

---

Is sql a dbms?

0 Answers  

---

What are the benefits of pl sql?

0 Answers  

---

Define union, minus, union all, intersect ?

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,

---

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

what is indexing, searching and user interface?

1 Answers   HCL,

---

How do I restart sql?

0 Answers  

---

Can we use joins in subquery?

0 Answers  

---

What is auto increment?

0 Answers  

---

How does a trigger work?

0 Answers  

---

How do you delete duplicates in sql query using rowid?

0 Answers  

---