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;

Why do we use bulk collect in oracle?

1104

---

Explain what are the uses of rollback segment?

1065

---

What are dml statements in oracle?

1130

---

How to define a record variable to store a table row?

1109

---

How to drop an index in oracle?

1118

---

Give the various rollback segment states.

1085

---

What is a named program unit?

1136

---

How to assign query results to variables?

1095

---

How many memory layers are in the oracle shared pool?

1251

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422

---

In oracle there is column command, how will you explain that?

1135

---

Explain about your project and its relation to the current job position you are applying to?

1075

---

Does oracle partitioning improve performance?

1051

---

what is the difference between restoring and recovering?

1052

---

How to write date and time literals in oracle?

1043

---