rem -----------------------------------------------------------------------
rem Filename:   d2kapps.sql
rem Purpose:    List Oracle Designer Applications
rem Date:       28-Apr-2000
rem Author:     Frank Naude (frank@onwe.co.za)
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
ORDER  BY NAME, VERSION DESC
/