oracle8.1.6 select nvl(max(v.sort_order),0) from acs_enum_values v where v.attribute_id = :attribute_id insert into acs_enum_values v (attribute_id, sort_order, enum_value, pretty_name) select :attribute_id, :sort_order, :pretty_name, :pretty_name from dual where not exists (select 1 from acs_enum_values v2 where v2.pretty_name = :pretty_name and v2.attribute_id = :attribute_id)