- 博客(2)
- 收藏
- 关注
原创 ORACLE中两种快照的写法
—10分钟前select * from slms.tsmdw51 as of timestamp sysdate-10/1440 where STACKING_STATUS>=3 and THROW_TIME=’ ';—固定时间点select * from slms.tsmdw51 as of timestamp to_date(‘20190527152000’, ‘yyyyMMddH...
2019-09-21 10:51:42 263
原创 多表多字段关联更新
update tsmdd57 a set (a.INVOICE_NO,a.INVOICE_CODE,a.TAX_PRICE,a.NO_TAX_PRICE,a.NO_TAX_AMOUNT,a.TAX_RATE,a.AMOUNT_TAX,a.TAX_AMOUNT,a.VOUCHER_NO,a.SALE_BILL_NO)=(select b.INVOICE_NO,b.INVOICE_CODE,b.TA...
2019-09-21 10:30:58 252 1
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人