VERSION 

Prerequisites

Log on to the database instance DEMODB.

Examples

You can use the system tableVERSION to determine the following database information, among other things:

·        Version of the software used by the currently active database instance

SELECT MAJORVERSION, MINORVERSION, CORRECTIONLEVEL, BUILD
  FROM SYSINFO.VERSION

·        Version of the operating system

SELECT OPERATINGSYSTEM
  FROM SYSINFO.VERSION

·        Kernel variant

SELECT KERNELVARIANT
  FROM SYSINFO.VERSION