oracle8.1.6 BEGIN :1 := rel_constraint.new( constraint_name => :constraint_name, rel_segment => :segment_id, rel_side => 'two', required_rel_segment => rel_segment.get(:supersite_group_id, 'membership_rel'), creation_user => :user_id, creation_ip => :creation_ip ); END; select t.pretty_name as package_name, acs_object.name(s.object_id) as object_name from site_nodes s, apm_package_types t where s.node_id = :node_id and t.package_key = :package_key select case when exists (select 1 from acs_object_types where supertype = :object_type) then 1 else 0 end from dual select object_type from acs_object_types start with object_type = :object_type connect by object_type = prior supertype select pretty_name, package_key from apm_package_types where not (apm_package.singleton_p(package_key) = 1 and apm_package.num_instances(package_key) >= 1) and implements_subsite_p = 'f' order by upper(pretty_name) and rownum < 2 order by decode(host, :search_vhost, 1, 0) desc and rownum < 2 select apm_parameter_value.new( package_id => :subsite_id, parameter_id => ap.parameter_id, value => ap.default_value) from apm_parameters ap where ap.package_key = :new_package_key and not exists (select 1 from apm_parameters ap2 where ap2.package_key = :old_package_key and ap2.parameter_name = ap.parameter_name)