摘要:
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 阅读全文
摘要:
SELECT DBMS_LOB.SUBSTR(r.CFPayReqNumber, 4000, 1) AS clob_content , r.CFPayReqNumber ,r.* FROM T_NT_ReceivableBill r where r.CFPayReqNumber LIKE '%ZDA 阅读全文