Check Version Information of Oracle Database

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

SAPGUI –> System –> Status


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;






Leave a Reply

× seven = 35