One can load data into an Oracle database by using the sqlldr (sqlload on some platforms) utility. Invoke the utility without arguments to get a list of available parameters. Look at the following example:
sqlldr scott/tiger control=loader.ctl
This sample control file (loader.ctl) will load an external data file containing delimited data:
load data
infile 'c:\data\mydata.csv'
fields terminated by "," optionally enclosed by '"'
into table emp ( empno, empname, sal, deptno )
Hope this helps.
Talent is what you possess;
genius is what possesses you