Answer Posted / venkat

select * from (
select e.deptno,d.dname,e.sal,dense_rank() over (
partition by e.deptno
order by e.sal desc ) "RANK",
e.ename
from emp_test e,dept_test d
where e.deptno=d.deptno)
where rank=2

What is an oracle data file?

1035

---

What is a sub query and what are the different types of subqueries?

1072

---

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

1018

---

What is translate in oracle?

1048

---

What are the system predefined user roles?

982

---

What is the difference between $oracle_base and $oracle_home?

1026

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

2289

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2197

---

How many data types are supported?

1021

---

How to write an inner join with the where clause in oracle?

994

---

How to best split csv strings in oracle 9i?

983

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4291

---

What is an oracle wallet?

880

---

How to commit the current transaction in oracle?

1042

---

When do you get a .pll extension in oracle?

1077

---