To find the Oracle DB Version to which you are connected now use the below queries.
The Results will be as below, The database version i used is 11.2.0.3
Sometimes the above command may result in Table or view doesn't exist error, reason can be you are not a DBA.
The Results for the above command will be like below.
select * from v$version;The Results will be as below, The database version i used is 11.2.0.3
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production"CORE 11.2.0.3.0 Production"
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - ProductionSometimes the above command may result in Table or view doesn't exist error, reason can be you are not a DBA.
The below can be used as an alternative.
select * from product_component_version;
The Results for the above command will be like below.
| PRODUCT | VERSION | STATUS |
| NLSRTL | 11.2.0.3.0 | Production |
| Oracle Database 11g Enterprise Edition | 11.2.0.3.0 | 64bit Production |
| PL/SQL | 11.2.0.3.0 | Production |
| TNS for Solaris: | 11.2.0.3.0 | Production |
No comments:
Post a Comment