Answer Posted / krishnakumar

select max_age,age
from
(select count(age) max_age,age from emp group by age order
by max_age desc)
where rownum < 2

What is the difference between 10g OEM and 11g OEM?

969

---

how to make an oracle object

2363

---

How to connect ms access to oracle servers?

1011

---

How to run queries on external tables?

1050

---

what are steps for interface? where is exchange rate defined in which table?

2162

---

Difference between oracle's plus (+) notation and ansi join notation?

1111

---

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

1057

---

When do we use group by clause in a sql query?

1041

---

How to handle a single quote in oracle sql?

1057

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

3207

---

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

1691

---

Explain about the analyze command in oracle?

1056

---

Does oracle charge for java?

1060

---

What is a nested table and how is it different from a normal table?

1056

---

 How to use an oracle sequence generator in a mapping?

1078

---