忘了捕获异常~~~~~~~~`

昨天调试程序的时候，忘了捕获异常，结果半天才发现原来是 程序出了异常，但是catch里面没写代码，所以显示起来我一直以为程序没错，原来是空值转换时候出了错，空值，和我玩了好几回了

还有一段oracle语句
"SELECT A.N002,A.N003,A.N001,A.N016,A.F001,A.N001||SUBSTR(RPAD(RTRIM(A.N016), 10, ' '),1,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.N002 IN ('000279','') 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"

连接|| 取子串，右端补空格，去掉右边空格，真麻烦阿