version-view-oracle.xql

DB Query file

Related Files

[ hide source ] | [ make this the default ]

File Contents

<?xml version="1.0"?>

<queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>

<fullquery name="apm_enabled_version_info">      
      <querytext>
    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

      </querytext>
</fullquery>

 
<fullquery name="apm_data_model_install_version">      
      <querytext>
    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

      </querytext>
</fullquery>

 
</queryset>