Answer Posted / arijit

donno whether the rest are correct ..but this one is:-
select max(sal) from emp where sal<(select max(sal) from emp
where sal<( select max(sal) from emp));

What is enter substitution variable in oracle?

578

---

What is the Tune Query

1849

---

What is a table index?

568

---

Explain joins in oracle?

561

---

How to convert characters to dates in oracle?

563

---

---

How to define a data source name (dsn) in odbc manager?

533

---

Is oracle a programming language?

570

---

How to assign values to data fields in record variables?

584

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2458

---

Will you be able to store pictures in the database?

642

---

what is a Nested Loop join?

1568

---

How to write a query with a right outer join in oracle?

622

---

How to execute the package in oracle?

576

---

What is an oracle wallet?

517

---

Define oracle database

598

---