Answer Posted / shareef

select * from(select emp.*,
dense_rank() over(partition by deptno order by sal desc) r
from emp) where r<=5;

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

980

---

How to check the oracle tns settings?

1048

---

What language does oracle use?

1112

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2473

---

How to create a stored function in oracle?

1112

---

How to create a new view in oracle?

1079

---

Explain oracle data types with examples?

1036

---

What is oracle join syntax?

1006

---

How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1916

---

What is the data pump export utility?

1087

---

What are the restrictions in a oracle read only transaction?

1040

---

Respected sir, Please send me technical questions related to oracle apps..

1815

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

What is a cursor in oracle?

1182

---

What is system tablespace?

1103

---