Yet another usefull oracle sql statement

Found another oracle sql statement that comes in handy, The following statement will list all tables that are owned by the myschemaName, along with some interesting facts about each table.

select * from all_tables
where owner = 'myshemaName';