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
  2. 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



Leave a Comment

Your email address will not be published. Required fields are marked *