Explain what is dbms?

0 Answers  

---

What are the benefits of using PL/SQL packages?

3 Answers  

---

Delete duplicate records in the emp table.

6 Answers   Oracle,

---

What is faster join or subquery?

0 Answers  

---

What is offset in sql query?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

Why we use triggers in mysql?

0 Answers  

---

What is sql used for?

0 Answers  

---

What is a primary key sql?

0 Answers  

---

What is bulk collections?

2 Answers  

---

How to prepare for oracle pl sql certification?

0 Answers  

---