1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?

2 Answers   Accenture,

---

Which is faster join or subquery in oracle?

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---

1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.

2 Answers   Wipro,

---

Explain database link?

0 Answers  

---

---

What is the difference between column level constraints and table level constraints?

14 Answers   IBM, TCS,

---

What is the database name in oracle?

0 Answers  

---

What are the tools for Oracle ?

0 Answers   Infosys,

---

How to build data dictionary view an new database?

0 Answers  

---

What is private procedure oracle?

0 Answers  

---

hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4

1 Answers   CTS,

---

How to use an explicit cursor without open statements?

0 Answers  

---