随笔分类 -  Oracle

Oracle 更新多字段1
摘要：UPDATE GSM_LOT A SET ( A.LOT_FLAG, A.ACTION_DATE ) = (SELECT 'O', CASE WHEN COL1 IN('0') THEN A.ACTION_DATE WHEN COL1 ='1' THEN DECODE(A.ACTION_DATE, NULL, SYSDATE, A.... 阅读全文
posted @ 2019-07-20 20:21 wangxinbo 阅读(183) 评论(0) 推荐(0)
Oracle小数格式化显示
摘要：Oracle 小数格式化 阅读全文
posted @ 2019-07-10 20:17 wangxinbo 阅读(1016) 评论(0) 推荐(0)