Answer Posted / abhijit

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
desc)
as rnk from table_name) where rnk=2;

Why do we need oracle client?

1009

---

How to establish administrator authentication to the server?

1099

---

What are the uses of a database trigger?

1037

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2200

---

What is a nested table and how is it different from a normal table?

1113

---

Explain view?

1091

---

How to execute a stored program unit?

1128

---

How do I recompile a procedure in oracle?

1018

---

Explain the use of compress option in exp command.

1073

---

How to grant create session privilege to a user in oracle?

1055

---

What is max rowid in oracle?

1085

---

Explain overloading. Can functions be overloaded?

1049

---

Write a syntax for update query in oracle?

1076

---

What are the four Oracle system processes that must always be up and running for the database to be useable?

1055

---

When do you get a .pll extension in oracle?

1194

---