RAVADA OA Blog
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment