Answer Posted / shahnaz

To find the 2nd highest salary from emp table:

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

How to put more than 1000 values into an oracle in clause?

969

---

How do I limit the number of oracle database connections generated by weblogic server?

1003

---

What is the difference between view and materialized view in Oracle?

1090

---

Describe an oracle table?

986

---

Name the various constraints used in oracle?

968

---

What exactly do quotation marks around the table name do?

915

---

What is an oracle and why it is used?

1076

---

Can you have more than one content canvas view attached with a window ?

2259

---

What is the quickest way to export a table to a flat file?

917

---

Define oracle database

991

---

Does facebook use oracle?

976

---

What is catalog in Oracle?

1262

---

How to get a list of all background sessions in the database?

942

---

How do I connect to oracle database?

1020

---

Explain the use of record length option in exp command.

1019

---