Answer Posted / neha

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

What to do if the binary spfile is wrong for the default instance?

1069

---

What is Java Pool in Oracle?

1167

---

Explain the use of parfile option in exp command.

1067

---

Can we call procedure inside function in oracle?

1084

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2457

---

How to shutdown your 10g xe server?

1147

---

What is the difference between alert log file and tarce file ?

2166

---

What is a snapshot in oracle database?

1025

---

What is the difference between $oracle_base and $oracle_home?

1086

---

What is an Oracle index?

1653

---

What is a user account in oracle?

1119

---

What is partitioned table in Oracle?

1185

---

Can we create trigger on materialized view in oracle?

990

---

How to speed up webrick?

1074

---

What is the difference between a user and a schema in oracle?

1034

---