Home » RDBMS Server » Server Utilities » sqlloader number formatting
sqlloader number formatting [message #249856] Fri, 06 July 2007 04:13 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
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.

thanx,
Dinesh
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: 64152
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

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


Current Time: Sat Dec 10 16:35:41 CST 2016

Total time taken to generate the page: 0.11175 seconds