Answer Posted / senthil

select column_name,count(*)from table_name group by
column_name having count(*)=(select max(count(*)) from
table_name group by column_name);

PLZ Contact Any Queries (raja.prem86@gmail.com)

what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?

2220

---

How to start your 10g xe server?

970

---

Whether any commands are used for months calculation? If so, what are they?

1042

---

Can we insert data in view oracle?

963

---

Explain rename?

925

---

What are the execution control statements in oracle?

1028

---

Why do we use bulk collect in oracle?

1012

---

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?

1326

---

How to use select statement to count the number of rows in oracle?

990

---

What happens to the current transaction if the session is ended?

1037

---

Why do we need integrity constraints in a database?

973

---

What is an oracle function?

1075

---

How to export data to a csv file?

1206

---

Explain about functional dependency and its relation with table design?

954

---

How to use like conditions in oracle?

996

---