Here are some useful queries when you’re looking at an Oracle database:

Getting Table Information

SELECT table_name, owner, tablespace_name FROM all_tables

Getting Column Information

SELECT column_name, table_name, data_type, data_length FROM user_tab_columns