Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQLLDR - loading a negative number

Status
Not open for further replies.

naushi

ISP
Jan 18, 2002
89
US
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.

Mark

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top