SSTS Blog

Some news and tidbits that we share

Scientific Notation and SQL Loader

by SSTS
SSTS
Server Side Technology Solutions is a consulting firm that specializes in databa
User is currently offline
on Jun 19 in Blog 0 Comments
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

Tags: Untagged
Hits: 13676

About the author

SSTS

Server Side Technology Solutions is a consulting firm that specializes in database design, development and support.

Comments

Please login first in order for you to submit comments