rahultripathi

 Profile Answers by rahultripathi 

• Sep 22nd, 2005

 

The SQL Loader is bulk loader utility which is used to move the data from a external file to database.One can use load data into database using sqlldr .

Ex:- 

load data

infile 'C:\rahul.csv' into emp table

 field are tarminated by "," optionaly inclose by' "  ' (empnao,name,id,sal)

if any problem Don't hesitate write rahultripathi@myway.com   

gvinoy

 Profile Answers by gvinoy 

• Jan 26th, 2006

 

SQL*Loader is a bulk loader utility used for moving data from external files into the Oracle database. Its syntax is similar to that of the DB2 Load utility, but comes with more options. SQL*Loader supports various load formats, selective loading, and multi-table loads.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. for example:sqlldr scott/tiger control=loader.ctlThis sample control file (loader.ctl) will load an external data file containing delimited data:[ load data infile 'c:\data\mydata.csv' into table emp fields terminated by "," optionally enclosed by '"' ( empno, empname, sal, deptno )]The mydata.csv file may look like this:[ 10001,"Scott Tiger", 1000, 40 10002,"Frank Naude", 500, 20]Another Sample control file with in-line data formatted as fix length records. The trick is to specify "*" as the name of the data file, and use BEGINDATA to start the data section in the control file. load data infile * replace into table departments ( dept position (02:05) char(4), deptname position (08:27) char(20) ) begindata COSC COMPUTER SCIENCE ENGL ENGLISH LITERATURE MATH MATHEMATICS POLY POLITICAL SCIENCE