Total Pageviews

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'))")

No comments:

Post a Comment