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

最新推荐文章于 2024-11-13 23:26:54 发布

web_gus

最新推荐文章于 2024-11-13 23:26:54 发布

阅读量1k

点赞数

分类专栏： other 文章标签： oracle null

本文链接：https://blog.csdn.net/web_gus/article/details/237089

版权

other 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

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

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