Thanks for the question, niranjan.
Asked: July 13, 2016 - 6:44 pm UTC
Last updated: July 14, 2016 - 12:58 am UTC
Version: sql developer
Viewed 1000+ times
You Asked
columns separated by ',' in data file but in control file by mistake if i mentioned field terminated '/' in control file.then what happen while loading data.
and Connor said...
So lets assume your data is:
123,456,789
and your control file (incorrectly) said: delimited by '/'
Then as we are reading the data, we will assume that "123,456,789" is the *first* field (because we didnt hit a delimiter yet).
So if that first field was (say) a VARCHAR2(50), then we would probably successfully load the *string* '123,456,789' into that column. But if it was defined as (say) NUMBER (because we were expecting to load something like 123 into it), then it would be rejected because of the embedded commas.
Hope this helps.
Rating
(1 rating)
Is this answer out of date? If it is, please let us know via a Comment