Hello There are few numeric formats when you load data from a file. I am looking for a way, if possible, to load a number from a field that doesn't have the decimal point. For example I may know that in my five-character field the first three characters always represent the most-significant digits and the last two are always the decimal values. Something like:
field 12345 would be loaded as 123.45 If, in data file, I have the value 123.45 I can use decimal external but wonder if I can avoid the decimal point in datafile. How can I define the field in control file? Thanks Witold ================================== Witold Iwaniec Sr Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
