Howto list the tables in an Oracle schema

To list the tables in an Oracle database run the following command. SELECT TABLE_NAME FROM TABS; This is very similar to the MySQL SHOW TABLES; command.