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. select * from v$version; 2. select version from v$instance; 3. select * from product_component_version;* Regarding the release number format, there is very good explanation on Oracle Doc site . Please go through it for details. Thanks!!