How to get the Oracle database version?

Question

How to get the version number of the running instance of oracle?

Answer 1

To get the detail on the running oracle instance version you can use any of the following command.

SELECT * FROM V$VERSION

or

SELECT version FROM V$INSTANCE