Home » RDBMS Server » Server Utilities » SQL*Loader
SQL*Loader [message #368040] Wed, 10 November 1999 12:51 Go to next message
Stephane
Messages: 4
Registered: November 1999
Junior Member
Hi,

I would like to load a text file into a database and create an associated table. I know I have to write a control file. But, could anyone send me or give me the structure and what I need to write in this file to do this.

Thanks a lot,

Stéph.
Re: SQL*Loader [message #368047 is a reply to message #368040] Fri, 19 November 1999 11:17 Go to previous messageGo to next message
mary
Messages: 19
Registered: November 1999
Junior Member
** Sample control file **

LOAD DATA
INFILE FLATFILE.txt
INSERT
INTO TABLE TEMP_EMP
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(EMP_NO SEQUENCE(MAX,1), ** these are the columns within the table created within SQL*Plus **
LAST_NAME,
FIRST_NAME,
TITLE,
ADD1,
PCODE,
HOME_TEL,
DATE_STARTED)
Re: SQL*Loader [message #368052 is a reply to message #368040] Wed, 24 November 1999 11:12 Go to previous message
Danny O'Reilly
Messages: 1
Registered: November 1999
Junior Member
Also see details posted at:

http://www.orafaq.com/papers/sqlload.doc

-Danny
Previous Topic: Y2K compliance
Next Topic: Re: SQL*Plus: Error accessing package DBMS_APPLICATION_INFO
Goto Forum:
  


Current Time: Thu Mar 28 05:16:26 CDT 2024