Originally posted by Michael Matola:
In Oracle
select * from all_tables ;
A note for the Oracle users: this will only list all the tables to which you have access. You only get all the tables in the database if the user you are logged in as has access to all the tables in the database. There is probably some equivalent command using the V$ tables, but I don't use them so I don't know the equivalent.