oracle8.1.6 select p.parameter_name, nvl(p.description, 'No Description') as description, v.attr_value, nvl(p.section_name, '') as section_name from apm_parameters p, (select v.parameter_id, v.attr_value from apm_parameter_values v where v.package_id = :package_id ) v where p.package_key = (select package_key from apm_packages where package_id = :package_id) and p.parameter_id = v.parameter_id order by section_name, parameter_name select p.parameter_name as c__parameter_name from apm_parameters p, (select v.parameter_id, v.attr_value from apm_parameter_values v where v.package_id = :package_id ) v where p.package_key = (select package_key from apm_packages where package_id = :package_id) and p.parameter_id = v.parameter_id