比较两个记录，仅显示差异 [英] Compare two records and show only the difference

问题描述

我想要一个Oracle Pipelined Function，它比较查询结果中的两个记录，并仅显示查询结果之间已更改的列?

I'd like a Oracle Pipelined Function which compares two records from a query result and shows only the column which have changed between the query result?

推荐答案

这不是您想要的，但是Kevin Meade在OracleFAQ上的博客提供了一个适用于我的解决方案:

Its not quite what you want, but Kevin Meade's blog on OracleFAQ has a solution which works for me:

http://www.orafaq.com/node/1826

http://www.orafaq.com/files/column_diffs.txt

这篇关于比较两个记录，仅显示差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！