重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: oracle 下查看表最近累计修改行数汇总 [打印本页]

作者: jiawang 时间: 3 天前
标题: oracle 下查看表最近累计修改行数汇总

SELECT table_owner, table_name, inserts, updates, deletes, timestamp AS last_modified_time
FROM dba_tab_modifications
WHERE table_owner = 'NRMS' AND table_name = 'NRMS_TREATMENT_EXECUTE';