No such thing as a small change | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Dear Monks,
I have am writing a script that will create sqlldr control files for me. I am having trouble printing 0. I am sure this a common problem that you wise monks have seen before and have overcome with easy. Here's my script: And here is a example of the bug: OPTIONS (ROWS=1) LOAD DATA INFILE * REPLACE INTO TABLE DECODE_TABLE FIELDS TERMINATED BY '|' TRAILING NULLCOLS ( VALUE, DESCRIPTION ) BEGINDATA 1|Something 2|Something else 3|Sometimes 4|Never 5|Always 6|Only once in a while 7|Once in a bluemoon |All the timeNote the line ... |All the time ... should of been outputted as ... 0|All the time As per this query below ... $ sqlplus blah... SQL> select * from DVAL_ADR_AVAIL 2 / V DESCRIPTION - ------------------------------ 1 Something 2 Something else 3 Sometimes 4 Never 5 Always 6 Only once in a while 7 Once in a bluemoon 0 All the time 8 rows selected.Please help! Thanks :) In reply to getting 0 to print by rbc
|
|