Answer Posted / sunil

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

or

select sal from(select sal,dense_rank() over(order by sal)
as rnk from table_name) where rnk=2;

What is format trigger?

2071

---

How to login to the server without an instance?

1162

---

What is the difference between postgresql and oracle?

1048

---

How to upsert (update or insert into a table)?

999

---

How many types of segments in Oracle?

1070

---

what is the dual table in oracle?

991

---

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

1013

---

How do I uninstall oracle client from windows?

1010

---

Explain a data segment?

1069

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2123

---

What is difference between sid and service name in oracle?

956

---

How to add a new column to an existing table in oracle?

1139

---

What is Segment Advisor in Oracle?

1104

---

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

1116

---

Explain the difference between sap and oracle?

1029

---