Thursday 18 April 2013

To find all available application version

select
ARU_RELEASE_NAME||’.'||MINOR_VERSION||’.'||TAPE_VERSION version,
      START_DATE_ACTIVE "when updated",
END_DATE_ACTIVE "when lasted",
CASE
WHEN
BASE_RELEASE_FLAG = 'Y'
Then 'BASE VERSION'
ELSE 'Upgrade'
END "BASE/UPGRADE",
ROW_SOURCE_COMMENTS "how it is done"
from
AD_RELEASES;

No comments:

Post a Comment