create table emp
insert into emp values (1,'Sam','','10');
insert into emp values (2,'Smith','Manager','10');
insert into emp values (3,'Dan','Clerk','');
insert into emp values (4,'Kyle','Clerk','20');
create table emp_1 as select * from emp;
Now run Compare data on these 2 tables.
It gives the following result:
So when the data volume is huge, it becomes another tasks to compare all the data just to find out that it wasn't able to compare null records.
I'm trying to figure out in case there is some setting in Toad which would help in comparing the records with null columns as well.
Please let me know if it provides clarity on the issue.