INSTANCE

Prerequisites

Log on to the database instance DEMODB.

Examples

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

·        Name with which the database instance can be addressed

SELECT node
  FROM SYSINFO.INSTANCE

·        Time at which the ONLINE operational state was reached

SELECT onlinestatedate
  FROM SYSINFO.INSTANCE