I've come up with a query that displays all tables and views of a specific owner. What I would like to do now, but am having an issue with, is that I would like to have a second column which line by line will indicate whether the field is a "table" or "view". Is this possible? if so, how might I go about this?
select table_name from all_tables where owner = '<owner>' UNION select view_name from all_views where owner = '<owner>' order by table_name;