Yesterday, I forgot to capture an abnormality. As a result, the half-day discovered is that the program has an exception, but there is no code in caratch, so I always thought that the program was correct, it turned out that there was a null value conversion time wrong, empty Value, and I have played a few times and have an Oracle statement "SELECT A.N002, A.N003, A.N001, A.N016, A.F001, A.N001 || Substr (rpad (RTRIM (A.N016 ), 10, ''), 10) || a.f001 || to_CHAR (A.N021, 'YYYY / MM / DD') AS NTOTAL, TO_CHAR (A.N119, 'HH: mi') AS N119 , To_char (a.n120, 'hh: mi') AS N120 from T12_NTZJSKKHNTBL A, T11_NKNRTBL B WHERE A.N021 = '2004/12/28' and A.N024 = '01 'AND (A.N002I) ',' ') OR A.N002 IS NULL) and A. N021 = B.N021 and A.N024 = B.N024 and A.N001 = B.N001 and A.N016 = B.N016 and A.f001 in ( 'A', 'b', 'd') and b.f004 in ('1', '2') and b.f002 = '0' ORDER BY A.N002, A.N001, A.N016 "
Connection || Take a skewers, right ends to make spaces, remove the right space, really troublesome
