Home » RDBMS Server » Server Utilities » sqlloader number formatting
sqlloader number formatting [message #249856] Fri, 06 July 2007 04:13 Go to next message
Messages: 36
Registered: May 2007
How to specify number formatting in control files while loading data using SQLLoader in oracle 10g.Also what are the various number format supported.

ex.If I want to load 55,55,55 then what should be the format and usage.

Re: sqlloader number formatting [message #249870 is a reply to message #249856] Fri, 06 July 2007 06:09 Go to previous message
Michel Cadot
Messages: 63912
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
55,55,55 is not a valid format number.
You have to create your own function to translate this string to a number and then use it in your SQL*Loader control file.

Database Utilities
Part II SQL*Loader
Chapter 9 Field List Reference
Section Applying SQL Operators to Fields

Previous Topic: sql loader - ROWS value being changed during execution
Next Topic: Exporting User Schema
Goto Forum:

Current Time: Sun Oct 23 15:35:27 CDT 2016

Total time taken to generate the page: 0.09847 seconds