I continuously forget the syntax for this (doesn’t help that it’s different in every database engine):
select table_name from user_tables;
Shows all user tables. You can also do:
select owner,table_name from all_tables;
which shows all tables.
To see what a particular table looks like, you can do: