What is pivot query?

0 Answers  

---

I have 2 packages A and B. Now package A references Package B and Package B references Package A. How do you compile such inter-dependent objects in PL/SQL

5 Answers   Doyensys, Infosys, Metric Stream,

---

what is pragma ?

1 Answers   Polaris,

---

What is sql and its types?

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

what is difference between stored procedures and application procedures,stored function and application function?

1 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 the difference between local variables and global variables?

0 Answers  

---

Why do we use cursors?

0 Answers  

---

Can a select statement fire a trigger?

0 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

---

How to get each name only once from an employee table?

0 Answers  

---