How to get the Oracle database version?

+1 vote
11 views
asked May 30 by Hitesh Garg (343 points)  

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

1 Answer

+1 vote
answered May 30 by Rahul Singh (518 points)  
selected May 30 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.
...