oracle8.1.6
select case when exists (select 1 from acs_object_types t where t.pretty_name = :pretty_name)
then 1 else 0 end
from dual
select replace(lpad(' ', (level - 1) * 4), ' ', ' ') || t.pretty_name, t.object_type
from acs_object_types t
connect by prior t.object_type = t.supertype
start with t.object_type = 'group'