常用SQL

查询前一天

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;