Answer Posted / raghav

select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3

What do you understand by a database object? Can you list a few of them?

1066

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1134

---

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2064

---

How to connect to oracle using service name instead of sid?

1072

---

Whats the benefit of dbms_stats over analyze?

2066

---

What is Redo Log Buffer in Oracle?

1282

---

What is a system tablespace and when it is created?

1018

---

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2271

---

How to change system global area (sga) in oracle?

1067

---

How to check database size in Oracle?

1257

---

Does oracle charge for java?

1115

---

Explain oracle insert into command?

1158

---

what are actual and formal parameters?

1159

---

Explain compound trigger in oracle?

1091

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2104

---