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:

desc sometable