ORACLE
越长大&越孤单
这个作者很懒,什么都没留下…
展开
-
多表多字段关联更新
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 评论 -
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 阅读 · 0 评论