There's more than one way to do things | |
PerlMonks |
getting 0 to printby rbc (Curate) |
on Jan 13, 2003 at 20:25 UTC ( [id://226582]=perlquestion: print w/replies, xml ) | Need Help?? |
rbc has asked for the wisdom of the Perl Monks concerning the following question:
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 :)
Back to
Seekers of Perl Wisdom
|
|