What does closing a cursor do?

0 Answers  

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

Is left join inner or outer?

0 Answers  

---

What is a merge query?

1 Answers  

---

what is self join and how it works??

2 Answers   Infosys,

---

What is right join sql?

0 Answers  

---

Are sql views compiled?

1 Answers  

---

Could you please provide oca (oracle 10g) dumps for my certification ?

1 Answers  

---

How will you make performance better for application including front end and back

2 Answers   Metric Stream,

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

Why use subqueries instead of joins?

0 Answers  

---

What is trigger in pl sql with examples?

0 Answers  

---