Answer Posted / akash

select emp_id,sal from ( select emp_id,sal from emp where
sal < ( select max(sal) from emp) order by sal desc ) where
rownum < 2;

How to define an oracle sub procedure?

1147

---

what is the difference between substr and instr function in oracle?

1091

---

6. Display the client name and order date for all orders using the traditional method.

2309

---

What do you understand by a database object?

1068

---

What are the data types in oracle?

1040

---

What do you mean by group by clause?

1047

---

Is there a function to split a string in plsql?

1064

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1990

---

What is using clause and give example?

1050

---

Why is oracle so popular?

1000

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2309

---

What is a cognitive schema?

973

---

How different is ms access and oracle?

1043

---

Explain joins in oracle?

1038

---

How to initialize variables with default values?

1249

---