Define commit, rollback and savepoint?

0 Answers  

---

define different types of trigger. : Sql dba

1 Answers  

---

What is the difference among union, minus and intersect?

0 Answers  

---

Suppose There is a string A.B....C.......D.........E........F In this string dots (.) are not having fixed count in between of string. I want the output to have string with one dot between. I.e. A.B.C.D.E.F

6 Answers   IBM,

---

When to use inner join and left join?

0 Answers  

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

Explain the steps needed to create the scheduled job?

0 Answers  

---

what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

Query for second maximum salary in each in each department

15 Answers   DST Global Solutions, TCS,

---

How do we tune the code?

2 Answers  

---

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 Answers  

---

What is ttitle and btitle?

0 Answers  

---