Database & SQL

 The SQL below lists tables and views together:

SELECT table_name "Name", 'Table' "Type"
  FROM all_tables
  WHERE OWNER = 'schemaname'
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'


Don't forget the views too:


Select * from all_views

where owner = 'schemaname'