flashback table org_tsalsale_kb to timestamp to_timestamp(‘2021-03-26 12:00:00’,‘YYYY-MM-DD HH24:MI:SS’);
select orgcode,jzdate from org_tsalsale_kb group by orgcode ,jzdate order by jzdate desc;
select * from org_tsalsale_kb where orgcode = ‘Q191’ and jzdate = ‘20210322’;
delete from org_tsalsale_kb where jzdate>=‘20210323’;
select 4839/3 from dual;
关于一次失误的挽救。
工作纪实(一)
最新推荐文章于 2024-05-28 21:59:16 发布