sqlloader Question
From: Ted M. Troccola X4721 <ttroccol_at_motown.ge.com>
Date: 1995/05/17
Message-ID: <3pcvbl$mo4_at_cnn.MOTOWN.GE.COM>#1/1
Date: 1995/05/17
Message-ID: <3pcvbl$mo4_at_cnn.MOTOWN.GE.COM>#1/1
I am using sqlloader to get data from a data file. The data file has like 10 columns in it. I am loading four tables which use some, but NEVER all, of the columns in the datafile.
So, I have to extract only these certain columns for certain tables.
Can this be done?
Load TABLE(emp, salary, age)
with (column_1, column_3, column_7)
from 'MY_10_COLUMN_DATA_FILE'
Thanks in advance,
Ted
Received on Wed May 17 1995 - 00:00:00 CEST