979755 wrote:Yes, check the link I posted to the fine Oracle® Database Utilities - Specifying Columns and Fields.
Being a novice with SQL*Loader, I will say no.
Is this something I can specify in the control file? If so, an example would be helpful.
979755 wrote:True, in your controlfile you set (for example): , zonedCol POSITION(x:y) ZONED(precision,scale)
Most helpful. Pardon a few follow-on questions:
1. The Zoned definition refers (I hope) to the data on the input file - regardless of the definition of the field field being loaded in the table (in my case the field in the table is defined as NUMBER) - is this a true statement?
2. If I am correct on item 1, if I have a negative number in the input file (let's say a negative 10) is a trailing sign loaded into the database (so it will be 10-)?NO, to deal with signed numbers, you set trailing signs as table column in a staging table and then apply to real table.
3. What happens to any leading zeroes when the data is loaded into the table?Ignored.
4. For dollar fields where the source has an implied decimal but I want an implicit decimal in loaded into the table and the number can be positive or negative, can I specify this as ZONED (10.2) in the control file?See answer #2.
5. And finally, regarding item 4 my understanding is that ZONED (10.2) would result in 12345678.12 (with a negative sign if appropriate) - is this a correct understanding?Nope, only the digits. That is why we use staging table to capture the sign.