Answer Posted / kss

Hi every one,

i know that we can get that thr above quer..

one can try using analytic function giving ranks to the
salary column

select sal,dense_rank() over(order by sal desc) rank from
emp

Describe an oracle table?

1049

---

How oracle handles dead locks?

1064

---

Is there any function in oracle similar like group_concat of mysql?

1050

---

What are the uses of Database Trigger ?

1715

---

How to loop through data rows in the implicit cursor?

1073

---

How to convert dates to characters in oracle?

1040

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1724

---

What is a package ? What are the advantages of package ?

1087

---

What do database buffers contain?

1024

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1070

---

What is oracle instant client?

1024

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2268

---

How to check the server version in oracle?

1092

---

What is the difference between substr & instr functions?

1225

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2900

---