摘要:
查单据附件sql: select * from T_BAS_Attachment t where t.fid in (select o.fattachmentid from t_bas_boattchasso o where fboid ='FqEAAAKEtufZvdiA') 1、t_bas_bo 阅读全文
摘要:
1、通过flashback query查询某历史时点的数据量,找到删除时间点的前1s,如 2020-05-13 16:38:07秒钟误删的数据: select count(*) from t_test as of timestamp to_timestamp('2020-05-13 16:38:06 阅读全文