Answer Posted / lakshmi

select sal from emp
where sal = (max(sal) from emp
where sal < (max(sal) from emp
where sal < (max(sal) from emp)));

What are the differences between char and varchar2 in oracle?

1071

---

Is java required for oracle client?

921

---

Explain what are clusters?

1041

---

What is the difference between sharding and replication?

953

---

Which is faster join or subquery in oracle?

931

---

What is the use of oracle?

980

---

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

1043

---

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

981

---

How do I call oracle stored procedures that take no parameters?

1017

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

971

---

How do you find current date and time in oracle?

985

---

How to count duplicated values in a column in oracle?

981

---

Explain a segment?

1017

---

How to drop an existing table in oracle?

1012

---

What is the usage of analyze command in oracle?

1029

---