How to get the Oracle database version?

+1 vote
438 views
asked May 29, 2018 by Hitesh Garg (352 points)  

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

1 Answer

+1 vote
answered May 29, 2018 by Rahul Singh (553 points)  
selected May 29, 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.
...