Answer / suman

what is indexing
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.

How do I get sql certification?

0 Answers  

---

I have one Excel file with 1,50,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . I need PLSQL Procedure or used by SQL PLUS

7 Answers   Polaris,

---

How to find the count of letter "L" in HELLO

7 Answers   HP,

---

Which nosql database is best?

0 Answers  

---

How would you pass hints to the sql processor?

0 Answers  

---

---

Can we create foreign key without primary key?

0 Answers  

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

What are stored procedures used for?

0 Answers  

---

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

---

Why is pl sql needed?

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  

---

What are functions in sql?

0 Answers  

---