How to get the Oracle database version?

+1 vote
422 views
asked May 30, 2018 by Hitesh Garg (352 points)  

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

1 Answer

+1 vote
answered May 30, 2018 by Rahul Singh (543 points)  
selected May 30, 2018 by Hitesh Garg
 
Best answer

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
Welcome to Codingeek Q&A, where you can ask questions and receive answers from other members of the community.
...