I have to test using SQL in Oracle if the data stored in the DB is completely correct or not. For example, make sure we are up to date, no future dates, no invalid characters on varchar columns, etc.

What is the best option for this kind of testing, given the fact that the only knowledge within the team is SQL.