manish shrivastava

• Feb 11th, 2006

 

Sql is a utillty by which we populate the by a opreting system file (say *.txt)

to decribe the table we use ctl file syntx is as follow

sqlldr user/passwd control=xxx.ctl log=abc.log data=lmn.dat

structure of ctl file is as follow

LOAD DATA
INTO TABLE "table name"
REPLACE
FIELDS TERMINATED BY WHITESPACE
TRAILING NULLCOLS
(
col1,
col2, .....
)

there are two technicq (as i know )to use sqlldr first i mention here i leave second one for your "SEARCH"

Rgds

Manish

sam

• Apr 1st, 2006

 

SQL Loader is a utility to load data on to an oracle database from an external source.

There are demo files to demonstrate the use of this uitility and the location is  C:\oracle\ora92\rdbms\demo

ALOK TANDON

• Jul 11th, 2006

 

SQL loader is a tool provided by oracle to load data into the tables through flat files.

SHEEL2006

• Feb 27th, 2007

 

SQL loader is a tool provided by oracle to load data, any other type of rdms file is converted into oracle rdms system

SrikanthPeru

 Profile Answers by SrikanthPeru 

• Aug 18th, 2007

 

SQL*Loader is a tool used to load flat files quickly into Oracle Tables. Using this, a single flat file can be loaded into multiple tables during the same load.

mala321

 Profile Answers by mala321 

• Dec 24th, 2007

 

Hello,

SQL * LOADER is a utility tool which comes inbulit with any versions of Oracle. it is used to load data (.txt,.xls, tables, Doc ...) any flat files of this type can be loaded into  Oracle database tables.

It can take one single flat file and load data into one table in Oracle DB or many tables at a single load
or
it can also take multiple flat files and load data too.
in SQL LOADER main  are

Control file , Data file , badlog file,discard file

control file  is the key file  which contains info about  remaining files DATA<BADLOG,discard

it also contains info about which table is going to be populated with this flat files
and datatypes....

Data file--which containd data in the form of a simple lines comma separated, delimiters...


so far this must be give you some idea. Good luck

bye
Mala