Database & SQL

 The SQL below lists tables and views together:

SELECT table_name "Name", 'Table' "Type"
  FROM all_tables
  WHERE OWNER = 'schemaname'
union
select view_name "Name", 'View' "Type"
from all_views
where OWNER = 'schemaname'
order by "Name"

This lists all the tables per schema. 

SELECT owner, table_name
  FROM all_tables

The schema name is the owner so you could filter this by where owner = 'schemaname'

http://stackoverflow.com/questions/205736/get-list-of-all-tables-in-oracle

 

Don't forget the views too:

 

Select * from all_views

where owner = 'schemaname'