Answer Posted / vanaja

select * from emp5 where salary in(select min(salary) from
emp5 where salary in(select top 3 salary from emp5 order by
salary desc))

What is a directory object?

1096

---

Differentiate between function and procedure in oracle.

1074

---

What are the limitations oracle database 10g xe?

1046

---

State any two functions of oracle?

1044

---

How to login to the server without an instance?

1162

---

What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1108

---

What is oracle rownum?

950

---

Can we write insert statement in function in oracle?

1087

---

Is oracle a programming language?

985

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1689

---

interview questions with answer for cts

2578

---

What is the Tune Query

2291

---

What is using clause and give example?

1036

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2024

---

Does facebook use oracle?

1031

---