Answer Posted / akshita

select * from (select e.*,rownum r from (select distinct
sal from emp order by sal desc) e) where r = 3

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2516

---

How to export your own schema?

583

---

Is truncate autocommit in oracle?

648

---

Is it possible to split the print reviewer into more than one region ?

1844

---

What is the use of aggregate functions in oracle?

589

---

---

How to list all tables in your schema?

619

---

What is Segment Advisor in Oracle?

678

---

How to create a stored program unit?

587

---

How to convert raw data type into text in oracle? Explain

607

---

State the various uses of dbcc command?

556

---

Differentiate between translate and replace?

635

---

Oracle

1865

---

How to use subqueries with the in operator using oracle?

621

---

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

560

---

How to return top 5 rows in oracle?

551

---