SQL语句在海量查询时尽量少用格式转换
Time:2016/03/26 02:49:45 Click:
如用
WHERE a.order_no = b.order_no
而不用
WHERE TO_NUMBER (substr(a.order_no, instr(b.order_no, '.') - 1) = TO_NUMBER (substr(a.order_no, instr(b.order_no, '.') - 1)
上一篇：Eclipse设置@author
