CSDN博客

img web_gus

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

发表于2005/1/1 21:41:00  918人阅读

昨天调试程序的时候,忘了捕获异常,结果半天才发现原来是 程序出了异常,但是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"

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

0 0

相关博文

我的热门文章

img
取 消
img即使是一小步
也想与你分享
打开
img