Re: how to set default vaule in sqlload with certain condition?

You could do this two ways, let sql ldr handle it, or put a default value on the column on the table for when a value is not specified. Try checking out the documentation for SQLLDR first.

Thanks,
Pete's

dhs_69_at_hotmail.com (David) wrote in message news:<7e64a3ea.0110041429.1ab8899a_at_posting.google.com>...
> HI,
>
> We try to use sqlload to load data, but I am not
> sure how to load data set to default value when
> certain condition happens.
>
> For example:
>
> table name :
> aa(ss_no not null, name);
> data file:
> "123","John"
> "","TOM"
> --------------------------------
>
> we try to load data if ss_no is null, we want to set value
> to 999999.
> so result look like:
>
> select * from aa;
> 123,John
> 999999,Tom
>
> Can sqlload can do this?
>
> Thanks
>
> David
Received on Fri Oct 05 2001 - 08:13:34 CDT