Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Single value comparison in PL/SQL question

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US