Explain the difference between replace() and translate() functions in oracle?

0 Answers  

---

write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"

7 Answers   British Telecom BT,

---

There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.

2 Answers   Microsoft,

---

How to filter out duplications in the returning rows using oracle?

0 Answers  

---

How do I recompile a procedure in oracle?

0 Answers  

---

---

What is meant by redo log buffer ?

2 Answers  

---

How to use "if" statements on multiple conditions?

0 Answers  

---

i want to know about mr.b.kotravel......who has answered for second maxmium salary from employee table

3 Answers  

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

What are joins..how many types of joins are there?

29 Answers   Amdocs, CSC, TCS,

---

What is SQL Tuning Advisor in Oracle?

0 Answers   MCN Solutions,

---

What are group functions in oracle?

0 Answers  

---