Sqlldr (SQL*Loader) example.

Question: I need an example of using the sqlldr (SQL*Loader) utility to load some data into my Oracle tables.

Answer: The sqlldr utility has easy syntax, and here is a simple example in using SQL*Loader. Also see this sqlldr (SQL*Loader) example.

Sqlldr dmuser/pswd control = c:/loader_bands.ctl log=c:/loader_bands.log

LOAD DATA
INFILE *
replace
into table web_desc_bands
(seqnum recnum,
type constant bands,
filename position(63:79),
text LOBFILE (filename)
terminated by EOF)
BEGINDATA
10/13/1995 06:21 PM 6,897 DSCWEBDEV\Decision Suppc:\sw\bands\1