Answer Posted / joel

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

Explain coalesce function?

624

---

What is transaction control statement and how many types of transaction control statement in Oracle?

562

---

How to write numeric literals in oracle?

608

---

How to use subqueries with the in operator using oracle?

608

---

Explain about functional dependency and its relation with table design?

550

---

---

Why oracle is used?

578

---

Explain self joins in oracle?

558

---

What is an oracle tablespace?

603

---

What is an oracle transaction?

585

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

566

---

What is the meaning of recursive hints in oracle?

531

---

How to convert raw data type into text in oracle? Explain

599

---

Name the three major set of files on disk that compose a database in Oracle?

631

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

603

---

What is a nvl function?

561

---