Answer Posted / mihir nasikkar

Here n is 3


SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

Which are the five query types available in oracle?

895

---

How many data types are supported?

1022

---

How to run create database statement?

975

---

How to insert a new row into a table in oracle?

1088

---

How would you begin to troubleshoot an ORA-3113 error?

2023

---

Explain the use of show option in imp command.

1045

---

How do I know if oracle client is installed on windows?

953

---

How to retrieve data from an explicit cursor?

1006

---

How to create a new oracle data file?

969

---

what are bitmap indexes? How does they work?

2182

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1861

---

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'));

1617

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1322

---

Where do we use decode and case statements?

942

---

What is analyze command used for?

1009

---