突然想起了ORACLE的分析函数。OK,使用 LAG select a,b,c,d from(select sbl.fee_terminal_id a,sbl.status b,smr.status c,smr.report_time d,lag(sbl.fee_terminal_id,1,0)over(partition by sbl.fee_terminal_id order by smr.report_...
SELECT sql_redo FROM v$logmnr_contents WHERE seg_owner='XXXXX' AND TABLE_NAME IN('XXXX','XXXX')AND OPERATION in('INSERT')or(operation in('DELETE','UPDATE')and upper(sql_redo)like '%WHERE%')这样对于update和delete操作都hi...
