Explain what are the advantages of views?

0 Answers  

---

How you open and close a cursor variable.Why it is required?

2 Answers  

---

What do you know about normalization? Explain in detail?

0 Answers  

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

What is a nvl function? How can it be used?

0 Answers  

---

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

How to rebuild an index in oracle?

0 Answers  

---

What are the common oracle dba tasks?

0 Answers  

---

how to find out second largest value in the table

8 Answers  

---

How to concatenate two text values in oracle?

0 Answers  

---

if you update view? where we store the data?

5 Answers   Cap Gemini,

---

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers  

---