Answer Posted / prasant

SQL> select max(sal) from emp where sal<(select max(sal)
from emp);

MAX(SAL)
----------
3000

How to install oracle odbc drivers?

707

---

What are the database administrators utilities available?

662

---

Describe the types of sub query?

636

---

Can we store images in oracle database?

645

---

What is raw datatype in oracle?

667

---

---

How to invoke the original export import utilities?

587

---

How to shutdown your 10g xe server?

706

---

How will you differentiate between varchar & varchar2?

667

---

How to convert dates to characters in oracle?

663

---

What the is the diff between local index and global index. give some example.

1236

---

Is there any function in oracle similar like group_concat of mysql?

639

---

What is partitioned table in Oracle?

733

---

Explain about your project and its relation to the current job position you are applying to?

638

---

What is the minimum client footprint required to connect c# to an oracle database?

643

---

How do I learn what codesets are available in oracle?

659

---