Here a quick list of queries that may help you to gain sometime while checking for objects
1. Getting the objects of the database:
Select * from DBA_OBJECTS where object_type like 'TABLE' AND owner like '%CAD'
2. Setting the format for date types in oracle sql developer
Go to Tools> Preferences > Database > NLS and set the Date Format as MM/DD/YYYY HH24:MI:SS