Oracle SQL Loader - ZONED keyword

[PhillipJones]

Oracle SQL Loader loads the following but sal is always
positive - the trailing sign is ignored ? Why ?
Thankyou.

load data
infile *
into table gbtemp
(empno integer external terminated by whitespace ,
ename char terminated by whitespace ,
sal zoned (7))
begindata
1234 Tom 0000001-
2345 Dick 0000002+
3456 Harry 0000003-

 

[Turkbear]

Hi,
Try
sal zoned(8)

The docs seem to imply that the sign is in the last byte and that the precision specifies the # of bytes.





To Paraphrase:"The Help you get is proportional to the Help you give.."