2 Ways to Check the Compatibility Level in Oracle (SQLcl & SQL*Plus)

Here are two ways you can use SQLcl or SQL*Plus to check your Oracle Database compatibility level.

Query the `v$parameter` View

You can query the v$parameter view to check the current value of the COMPATIBLE initialisation parameter.

Example:

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

Example result:

19.0.0

In this case, my database is completely compatible with this software version.

Another way to do it is to run a query against database_compatible_level:

SELECT value
FROM database_compatible_level;

Example result:

19.0.0

Obviously, the result you get will depend on your database compatibility level.