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