Home » RDBMS Server » Server Utilities » SQLLOADER - DATA TYPE PROBLEM
SQLLOADER - DATA TYPE PROBLEM [message #71249] Tue, 01 October 2002 04:55 Go to next message
Naveen
Messages: 75
Registered: June 2001
Member
Hi!

I got a problem while runing the Control file. It is loading the data but my data is as below
1,10.91
2,10.80

it is loading the data in to oracle but when it has to store as 10.80 it is storing only 10.8 and not storing the zero.

If any 1 can help me out .....i will be very thanqful

waiting 4 some 1 help

naveen

Report message to a moderator

Re: SQLLOADER - DATA TYPE PROBLEM [message #71251 is a reply to message #71249] Tue, 01 October 2002 05:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
that is expected.
and i beleive, there will no harm in that.
a traling zero after a decimal point is of no use??

Report message to a moderator

Previous Topic: Oracle installation on windows 2000
Next Topic: Terminating sqlloader
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Apr 28 18:59:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.