Re: Can anyone explaining what's happening !!!

Hi!

fumi wrote in message <7b3bnh$hta$2_at_news.seed.net.tw>...

[snip]

>
>
>Since the data in your file are expressed as characters,
>you can specify the date type "CHAR" in spite of the column data type, as
>following:
>

[snip]

I think the type specification in the control file is used for value checking, so there will be a difference to "who" detects an ill-formed number - sql*loader or the database.

Regards,

Roy Brokvam
roy.brokvam_at_conax.com Received on Fri Feb 26 1999 - 05:18:11 CST