Answer Posted / mahesh

SELECT *
FROM (SELECT ROWNUM sl, salary
FROM (SELECT DISTINCT salary
FROM employees
ORDER BY salary))
WHERE sl = n

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

1688

---

How can I create database in oracle?

1010

---

Explain parameter file in oracle.

1021

---

Please explain oracle data types with examples?

1060

---

How to rename an index?

1067

---

How to sort the query output in oracle?

1023

---

How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?

2825

---

Explain the truncate in oracle?

963

---

What are the logical operations?

1119

---

How to build data dictionary view an new database?

1002

---

Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?

1010

---

Can you tell me how to add new column in existing views?how?How is possible?

1434

---

How to use "in out" parameter properly?

1044

---

How to do clean up if create database failed?

1026

---

What are the major difference between truncate and delete?

1050

---