What is the usage of nvl function?

0 Answers  

---

What is an exception in pl/sql?

0 Answers  

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

0 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

I need to write a simple query,which one is better select statement or stored procedure?and why?

2 Answers   iGate,

---

---

What is rowtype?

0 Answers  

---

What are the different tcl commands in sql?

0 Answers  

---

How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?

0 Answers  

---

What is the use of primary key?

0 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  

---

how to use case expression? : Sql dba

0 Answers  

---

What does (*) mean in sql?

0 Answers  

---