Answer / 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 are the different types of cursors? explain?

4 Answers  

---

How to view the dropped tables in your recycle bin?

1 Answers  

---

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

1 Answers   IBM,

---

Explain the use of log option in exp command.

1 Answers  

---

What are the major difference between truncate and delete?

1 Answers  

---

Is it possible to split the print reviewer into more than one region ?

1 Answers   Oracle,

---

What is a server parameter file in oracle?

1 Answers  

---

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

0 Answers   Wipro,

---

What is cluster Key ?

3 Answers  

---

Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.

1 Answers   Wipro,

---

What is the parameter mode that can be passed to a procedure?

1 Answers  

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---