Get Oracle Version details

In this small post, I am sharing the commands to get details about the oracle version you are using. Although much detail is there in Oracle documentation, but thought of sharing this small tips :).

Steps:

Connect to Oracle DB using CLI or UI tool as you wish. Here I am connecting with Oracel SQL Developer. There are number of ways for getting the details. I sharing below ones.

1. select * from v$version;

1.    2. select version from v$instance;
2. 
   
3. 
               3. select * from product_component_version;*
4. 
   
   
5. Regarding the release number format, there is very good explanation on Oracle Doc site. Please go through it for details.
6. Thanks!!