Re: Comparing two rows

From: Carlos <>
Date: Thu, 25 Feb 2010 01:00:24 -0800 (PST)
Message-ID: <>

On Feb 25, 1:51 am, Rich <> wrote:
> I am using 10g.
> I have an audit trail stored procedure to create. There is a customer
> table. Then customer_audit table. Customer and Customer_audit tables
> are identical. Each time a record is changed, a copy of the old record
> is sent to Customer_Audit.
> My report needs to compare the record in the customer table verses the
> one in the audit table.
> I basically want my code to go field by field and spot the
> differences. I intend to send differences to a table.
> I know that I can do this with cursors. Is it possible to do this with
> an SQL statements?

Isn't it the good ol' "journal"?


Carlos. Received on Thu Feb 25 2010 - 03:00:24 CST

Original text of this message