I looked up the SQL to display a list of tables I created in Oracle DB, so taking notes.

SELECT TNAME FROM TAB;
SELECT TABLE_NAME FROM USER_TABLES;

Either of these will work.

By the way, for MySQL:

show tables;

And for PostgreSQL:

\\dt

That’s all from the Gemba regarding database table listing commands.

【References】

・oracleでテーブル一覧を表示する - Linoブログ