Checking the Compatibility Level of Oracle Database

Use this SQL query to find the COMPATIBLE initialization parameter value set for your database.

SQL> SELECT name, value FROM v$parameter
         WHERE name = 'compatible';