Getting the current Oracle version (SQL Select)
Queries :
select * from v$version; select * from product_component_version;Results :
| Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production PL/SQL Release 11.1.0.6.0 - Production CORE 11.1.0.6.0 Production TNS for Solaris: Version 11.1.0.6.0 - Production NLSRTL Version 11.1.0.6.0 - Production |
| PRODUCT | VERSION | STATUS |
| NLSRTL | 11.1.0.6.0 | Production |
| Oracle Database 11g Enterprise Edition | 11.1.0.6.0 | 64bit Production |
| PL/SQL | 11.1.0.6.0 | Production |
| TNS for Solaris: | 11.1.0.6.0 | Production |
8 comments:
Thanks man. Verry useful.
very usefull . good
Thanks for that! Helped us a lot.
Good stuff!
thanks!
Thanks!
Thanks
Thanks a lot!It worked perfectly.
Post a Comment