Answer Posted / tanuj tewari

select max(sal) from table_name where sal<(select max(sal)
from table_name);

what is the use of system.effective.date variable in oracle?

1113

---

Does oracle partitioning improve performance?

992

---

What is a named program unit?

1075

---

if you ctreate table identity

2372

---

How can Oracle users be audited?

1115

---

What is merge statement used for?

1024

---

What is difference between truncate and delete?

1040

---

Can we store pictures in the database and if so, how it can be done?

1043

---

How to use existing values in update statements using oracle?

1066

---

What is ADDM Advisor in Oracle?

1173

---

how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....

2061

---

Explain the use of parfile option in exp command.

1068

---

What is the oracle implicit cursor?

1062

---

Can a formula column be obtained through a select statement ?

2322

---

How to view existing locks on the database?

1053

---