| Mapping 1 column in Input File to Multiple Table Columns [message #70385] |
Thu, 06 June 2002 05:01  |
vivek
Messages: 59
Registered: October 2001
|
Member |
|
|
Hi,
I have a basic question here... If I have just One column in the input file to sqlldr ( specified using the INFILE parameter in the SQLLDR command ), what can I write in the Control File to map the value to more than one database Table-columns.
Thanks in Advance,
Vivek.
|
|
|
|
|
|
| Re: Mapping 1 column in Input File to Multiple Table Columns [message #70398 is a reply to message #70385] |
Fri, 07 June 2002 12:25  |
Mike
Messages: 417
Registered: September 1998
|
Senior Member |
|
|
TRY
------------------------------------------------------
test.dat
~12~
~13~
~14~
------------------------------------------------------
TABLE A(A1 NUMBER, A2 VARCHAR2(30), ...)
TABLE B(B1 NUMBER, B2 NUMBER, B3 VARCHAR2(30), ...)
TABLE C(C1 NUMBER, C2 VARCHAR2(30), C3 NUMBER, ...)
------------------------------------------------------
test.ctl
LOAD DATA
INFILE 'test.dat'
APPEND
INTO TABLE A
FIELDS TERMINATED BY '~' OPTIONALLY ENCLOSED BY '"'
(A1 INTEGER EXTERNAL)
INTO TABLE B
FIELDS TERMINATED BY '~' OPTIONALLY ENCLOSED BY '"'
(B2 INTEGER EXTERNAL)
INTO TABLE C
FIELDS TERMINATED BY '~' OPTIONALLY ENCLOSED BY '"'
(C3 INTEGER EXTERNAL)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
