SQL*Loader
Date: Sat, 13 Oct 2001 17:41:21 +0800
Message-ID: <3bc80bfb_2_at_news.tm.net.my>
Hi all,
A few queries on SQL*Loader... While loading data from a text file into a table, I want to
(1) default some values - which are not present in the text file - into the
certain columns of a table... E.g. there is a column in the table called as
Migrated_From. When I load the data, I want this column to have, let's say,
'XYZ'... I can't create this column with a DEFAULT clause, because when this
column is being updated through an application, it should be defaulted with
some other value....
(2) check if a column in the text file is null and if it is then default the
some value in the column... something like NVL ()... E.g. a column NAME is
created with the not null constraint... but while migrating I may not get
any data for this column, in which case, I want to put a '*' in this
column....
Any suggestions????
Thanks and regards,
Aparna
Received on Sat Oct 13 2001 - 11:41:21 CEST