|Problems? Is your data what you think it is?|
getting 0 to printby rbc (Curate)
|on Jan 13, 2003 at 20:25 UTC||Need Help??|
rbc has asked for the
wisdom of the Perl Monks concerning the following question:
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 :)