随笔分类 -  oracle

• sql一些实用技巧收集
  摘要：--字符串表达是求值 WITH T AS ( SELECT '1+2+3+4' express FROM DUAL UNION ALL SELECT '21+2+32+4' FROM DUAL UNION ALL SELECT '41+22+13+4' FROM DUAL ) SELECT dbms_aw.eval_number(express ) FROM T ... 阅读全文
  posted @ 2016-07-28 09:02 道三自留地 阅读(256) 评论(0) 推荐(0)