oracle8.1.6 select version_id as installed_version_id, version_name as installed_version_name, enabled_p as installed_enabled_p from apm_package_versions where package_key = :package_key and installed_p = 't' and rownum = 1 select data_model_installed_version from ( select version_name as data_model_installed_version from apm_package_versions where package_key = :package_key and data_model_loaded_p = 't' order by apm_package_version.sortable_version_name(version_name) desc ) where rownum = 1