Answer Posted / akash

select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1583

---

How translate command is different from replace?

546

---

What is memory advisor in Oracle?

635

---

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

552

---

How to drop an existing table in oracle?

592

---

---

is there a tool to trace queries, like profiler for sql server?

603

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

1807

---

What is private procedure oracle?

529

---

How do you bind variables in oracle?

544

---

How to apply filtering criteria at group level in oracle?

587

---

How to rename an existing table?

607

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1879

---

Difference between inner join vs where ?

607

---

how the indexes are stored in the Oracle Database?

1738

---

How to lock and unlock a user account in oracle?

612

---