Comparing 1 Cursor Against Another

[vimy]

Hello,

I'm a little new and pl/sql and I am wondering if there is a way to compare the current record of a cursor to the current record of another cursor.

If this is not possible, is there an easy way to compare a large number of fields without doing it manually?

Thank in advance

 

[Morpheus1981]

Can u be more specific... ?????

 

[rcurva]

You can do a minus on the SQL statements of those cursors:

SELECT *
FROM table1
where ...
MINUS
SELECT *
FROM table2
where ....;

(Assuming all fields of these two tables are the same, if not, you'll have to do it manually)