Hi all, I am going to write oracle certification. Can anyone send me the dumps available if any for OCA exam? Its really very urgent, prompt response will help me alot..

8 Answers  

---

What is difference between sql and oracle?

0 Answers  

---

Explain two easy sql optimizations.

0 Answers  

---

What types of commands can be executed in sql*plus?

0 Answers  

---

what is transaction? : Sql dba

0 Answers  

---

What is the Difference between Procedure and Function.Can we call a Function in a DML?

2 Answers   TCS,

---

What sql database should I use?

0 Answers  

---

What is the use of a view in sql?

0 Answers  

---

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

2 Answers   iGate,

---

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  

---

Can a key be both primary and foreign?

0 Answers  

---

What are the return values of functions SQLCODE and SQLERRM ?

2 Answers   PreVator,

---