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
...
User Profile
Collapse
-
URGENT..!!!!! Can any 1 Give me query for this pls?
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...
No activity results to display
Show More