Re: Comparing two rows
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Thu, 25 Feb 2010 01:00:24 -0800 (PST)
Message-ID: <f52df4fd-83f5-482e-899a-d189406f845e_at_f8g2000yqn.googlegroups.com>
On Feb 25, 1:51 am, Rich <richma..._at_earthlink.net> 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?
Date: Thu, 25 Feb 2010 01:00:24 -0800 (PST)
Message-ID: <f52df4fd-83f5-482e-899a-d189406f845e_at_f8g2000yqn.googlegroups.com>
On Feb 25, 1:51 am, Rich <richma..._at_earthlink.net> 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"?
Cheers.
Carlos. Received on Thu Feb 25 2010 - 03:00:24 CST