I am accessing a Oracle database via MS ODBC. My problem is that I cannot see what type of relations exist between the tables (inner join, outer join). Sometimes the datatypes aren't transported the right way (numbers are converted to text and brake relations).
Is there a way to access metadata like relations and data types from an office computer the right way?
Thank you very much.