>
> Is there are a function/procedure to compare tables and contents?
>
> Thanx
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892  Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
 

You could use MINUS to do that, provided datatypes are the same
select col1, col2
from table1
minus
select col1, col2
from table2
will return the rows from table1 where the columns don't match

Hth,

Sybrand Bakker, Oracle DBA