—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’, ‘yyyyMMddHH24miss’) where STACKING_NO = ‘6C13190524029125’;
ORACLE中两种快照的写法
最新推荐文章于 2024-06-18 15:57:47 发布