Oracle: show all tables in a DB

 As we all know, there is a SHOW TABLES sql command in MySQL, in Oracle, it is:

SELECT table_name FROM dba_tables;

notice in the FROM clause there is a dba_tables which shows all tables used by oracle, use user_tables to only show your own table.