select comp_id, comp_name, status, schema from dba_registry order by comp_name;