Answer Posted / gaurav

try this

select max(salary)
from employees
where salary < (select max(salary)
from employees
where salary < (select max(salary)
from employees));

How to create a stored function in oracle?

1112

---

List out the components of logical database structure of oracle database.

1040

---

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

2002

---

What is PL/SQL ?

2080

---

Give the constructs of a package, function or a procedure.

1053

---

What is a dead lock in oracle?

1129

---

What is the difference between post-database commit and post-form commit?

1206

---

What happens if you set the sga too low in oracle?

1156

---

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

1075

---

What is ceil and floor in oracle?

1073

---

How to count groups returned with the group by clause in oracle?

1081

---

What is bulk load in oracle?

1076

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

---

How to install oracle odbc drivers?

1095

---

material view and view disadvantages?

1079

---