How to check Oracle database version?

So today I needed to check what was my Oracle version because the PARTITION is not working and as far as I understand my version is not compatible with it. Here’s how to do it.

  1. Log in as sysdba
C:Usersrecon1>sqlplus / as sysdba
  1. Run the following query
SQL> select * from v$version;

Oracle Database 11g Express Edition Release - Production
PL/SQL Release - Production
CORE Production
TNS for 32-bit Windows: Version - Production
NLSRTL Version - Production