rem ----------------------------------------------------------------------- rem Filename: d2kapps.sql rem Purpose: List Oracle Designer Applications rem Date: 28-Apr-2000 rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- col application format a30 col version format 999 col title format a40 trunc select NAME APPLICATION, VERSION, DISPLAY_TITLE TITLE from CI_APPLICATION_SYSTEMS WHERE LATEST_VERSION_FLAG = 'Y' ORDER BY NAME, VERSION DESC /