Hi

I want to use SQL*Loader , an Oracle-supplied utility to load data from a flat file into one database tables.
for this I have write the scripts in the SQL*LOADER control file named loader.ctl. actual data file is mydata.csv that I have mentioned under ‘load data’ section in loader.ctl .
P.N : I am using my personal oracle installed on windows Pc. not using any n/w resources to access oracle DB
...

EmpNo DeptNO
2001 10
2002 20
2003 30
2004 20
2005 10
2006 30
2007 20
2008 10
2009 30
2010 30
2011 20
2012 30

GUYS I WANT FOLOWING OUTPUT

COUNT DEPTNO
3 10
4 20
5 30

can some1 pls give me Oracle SQl query to count the frequency of a value in...