We are loading a number -1234567 into a Number(7) datatype using SQLLDR. willit work to just bring the data as -1234567 or do I have to do differently. Also is Number(7) sufficient?
Thanks in advance. Regards,
Naushi Hussain
Naushi.hussain@honeywell.com
Not sure why it took so long for someone to say: Yes. SQL Loader will do the number conversion and the (?) value in a number declaration is its character length, regardless of neg/pos. That said, ensure you are using a delimited file or you account for the 8 characters within the control file to represent your number with a minus sign.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.