Check for data consistency oracle etl

I am new to oracle and I would like to know how do we check for misuse of integrity constraints and length of datatypes as part of the ETL testing process. (The two tables could be T1 and T2). Please let me know a sample query.

Thanks, Santosh