Showing posts with label SQL Loader logic for Negative Vlues. Show all posts
Showing posts with label SQL Loader logic for Negative Vlues. Show all posts
Thursday, May 7, 2015
Sql Loader for loading Negative Numbers
For Example, negative number value is '0000-145.23'.
Logic for Sql Loader for Negative Values :
LOAD DATA
replace preserve blanks INTO TABLE test_neg
(amount position(1:7) DECIMAL EXTERNAL "to_number(to_char(ltrim(:amount,'0'),'s9999999999.99'))")
Subscribe to:
Posts (Atom)