What are the advantages of sql?

0 Answers  

---

Is primary key a clustered index?

0 Answers  

---

What is a rank in sql?

0 Answers  

---

Explain the types of joins in sql?

0 Answers  

---

Is pl sql different from 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,

---

Can we rollback truncate?

0 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

in procedure how to return a value

3 Answers   Wipro,

---

What is the difference between partition and index?

0 Answers  

---

What does fetching a cursor do?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---