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

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1959

---

What is primefaces used for?

1098

---

How can you use check constraints for self referential integrity?

1018

---

What is the simplest tool to run commands on oracle servers?

1053

---

Can you have more than one content canvas view attached with a window ?

2373

---

How to get execution path reports on query statements?

1045

---

how can we store any pdf file in oracle

2222

---

How will you identify oracle database software release?

1058

---

What happens if variable names collide with table/column names?

1269

---

What is the quickest way to export a table to a flat file?

1013

---

Define oracle database

1099

---

What privilege is needed for a user to connect to oracle server?

1034

---

What are the differences between interval year to month and interval day to second?

1067

---

Can we store pictures in the database and if so, how it can be done?

1090

---

What is a read only transaction in oracle?

1081

---