查询前一天
select sysdate-1 from dual;
更新创建日期为前一天
update dis_specimen a set a.create_time = sysdate -1 where a.barcode in (201810260400,201810260300,201810260200,201810260100);
表赋权给用户
grant 权限 on 表名 to user;
select sysdate-1 from dual;
update dis_specimen a set a.create_time = sysdate -1 where a.barcode in (201810260400,201810260300,201810260200,201810260100);
grant 权限 on 表名 to user;