Single value comparison in PL/SQL question

From: Gennady <gennadyb_at_halcosoftware.com>
Date: 2000/05/02
Message-ID: <390f4d23$0$6549@fountain.mindlink.net>#1/1

Hello,
In my Oracle 8.0.5 database I have 2 tables (T1 and T2) which have same structure. I need to create PL/SQL procedure using cursors on T1 and T2 to make a single data value comparison. In Visual Basic it looks like this:
FOR k=0 TO ColumnCount - 1

      IF OraDynaSet1.Fields(k).Value <> OraDynaSet2.Fields(k).Value THEN
          vSameValue = FALSE


         /* ...Do something */

      ELSE
          vSameValue = TRUE


         /* ...Do something */

       END IF

NEXT k
Is it possible in PL/SQL and how?

Thanks,
Gennady Received on Tue May 02 2000 - 00:00:00 CDT