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

Report message to a moderator

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: 68665
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jul 01 11:08:28 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.