Check Version Information of Oracle Database

We can easly find our ORACLE database version via SAPGui like below ;

SAPGUI –> System –> Status

oraversionsapgui

But if we want to get more information about the version of our ORACLE dataase , then we should use the following SQL Syntax for it ;

select * from (select version || ‘.’ || id as V from dba_registry_history where namespace=’SERVER’ order by ACTION_TIME desc) where rownum = 1;

orapatchcheck

 

 

 

 

Leave a Reply


+ one = 3

Blogroll