随笔分类 -  oracle

12
摘要：snocd8bc194c06c7e80665a4007df09f6f8 阅读全文
posted @ 2015-11-30 16:55 webzhang
oracle对字段进行大写和小写
摘要：对oracle数据进行大写转换用 upper()函数，对数据进行小写转换用lower()函数。select * from SYS_User where upper(UserName)='ADMIN'select * from SYS_User where lower(UserName)='admin... 阅读全文
posted @ 2015-11-12 15:28 webzhang 阅读(2664) 评论(0) 推荐(0)
OCI-22053: 溢出错误
摘要：oracle有一种错误OCI-22053: 溢出错误，一种情况就是小数点后太多位数。用round((1-SUM(OutNoQualifiedNum)/SUM(OutPeccancyNum)),5)函数保留小数点后5位例如：SELECT SUM(CASE WHEN OutPeccancyNum=0 T... 阅读全文
posted @ 2015-11-05 15:31 webzhang 阅读(1067) 评论(0) 推荐(0)