title: How to count different values in one column of table in Oracle 10g?
body: <p>I have a situation where i have to count number of strings of same type in one column of a table, for eg. a column would be having values such as :-</p>
  
  <p>apple, apple, apple, orange,orange, banana, banana, banana, banana</p>
  
  <p>So i need to count all the strings of same type, that means query should give count result 3 for apples, 2 for oranges and 4 for banana.</p>
  
  <p>What can be idol query for this?</p>