how to write date and time literals? : Sql dba

0 Answers  

---

Can we write dml inside a function in sql server?

0 Answers  

---

1. what is the exact use of hint in sql. 2. How we can avoid index scan in sql even though index is there in the table.

1 Answers   Polaris,

---

What is pivot table in sql?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

Is sqlite good enough for production?

0 Answers  

---

What are indexes, and what are the different types?

3 Answers  

---

What is PL/SQL table ?

6 Answers  

---

What are pl/sql packages?

0 Answers  

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What can I use instead of union in sql?

0 Answers  

---

Why do we use function in pl sql?

0 Answers  

---