sqlexasol

How to find the EXASOL server version with SQL

I'm looking for a SQL query to provide me with the Exasol server version, similar to this in Oracle:

-- Oracle
select * from v$version;

-- PostgreSQL:
select version();

How can I do it?

Solution

  • This is also an option:

    select *
from "$ODBCJDBC".DB_METADATA
where name in (
      'databaseIncrementVersion'
    , 'databaseMajorVersion'
    , 'databaseMinorVersion'
    , 'databaseProductVersion'
    , 'databaseName'
    , 'databaseProductName'
    , 'revisionNumber');