SQL*Loader [message #368040] |
Wed, 10 November 1999 12:51 |
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 |
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)
|
|
|
|