SELECT name, type FROM ( SELECT 1 AS ord, owner||'.'||table_name AS name, 'TABLE' AS type FROM all_tables WHERE owner NOT LIKE '%SYS%' UNION ALL SELECT 2 AS ord, owner||'.'||table_name, 'SYSTEM TABLE' FROM all_tables WHERE owner LIKE '%SYS%' UNION ALL SELECT 3 AS ord,owner||'.'||view_name, 'VIEW' FROM all_views WHERE owner NOT LIKE '%SYS%' UNION ALL SELECT 4 AS ord,owner||'.'||view_name, 'SYSTEM VIEW' FROM all_views WHERE owner LIKE '%SYS%' ) ORDER BY ord, name;