Sometimes you receive data in scientific notation. The way to handle this when using sql loader is to utilize the FLOAT EXTERNAL directive in the sql loader controlfile.
ex
STD_DEV FLOAT EXTERNAL... Sometimes you receive data in scientific notation. The way to handle this when using sql loader is to utilize the FLOAT EXTERNAL directive in the sql loader controlfile.
ex
STD_DEV FLOAT EXTERNAL

Read more http://billennis-ssts.blogspot.com/2008/06/scientific-notation-and-sql-loader.html