This content has been marked as final. Show 5 replies
Please update your forum profile with a real handle instead of "974850".
How can I determine version of oracle database from APEX. Is there any built in table or view is available in APEX?No, the required features are built-in to the database.
In SQL there are various data dictionary views containing this information. The PRODUCT_COMPONENT_VERSION view is public, whereas the others may require additional privileges:
In PL/SQL there is the <tt>dbms_utility.db_version</tt> API procedure:
select version from product_component_version where product like 'Oracle Database%';
I think using the documented API is the way to go.
declare v varchar2 (20); c varchar2 (20); begin dbms_utility.db_version(v, c); dbms_output.put_line(v); end; /
Is it possible from Shared Component?What do you mean? If the DB version is information that is required globally by your application, then retrieving it into an application item using an application computation would be the recommended approach. Application items/computations are APEX shared components.