Search code examples
sqloracle-databaseversion

Query to get Oracle DB version

I'm looking for a way to get an Oracle DB Server version as "X.Y.Z".

I can use a query from here, but it will show a version of not just a server.

I can use v$version view but the resulting string will contain much more than just "X.Y.Z".

Is there a simple way to get what I want?

Solution

  • Why not just query v$instance?

    SQL> select version from v$instance;

VERSION
-----------------
12.2.0.1.0

    No need to muck around with pl/sql or called procedures.