This content has been marked as final. Show 5 replies
Check out the bottom right of each page in the application builder.
Do you need to know db instance details, then check here
SQL Workshop->Utilities-> About Database->Database Administrator Login -> dba role -> details will display.
For db info:
For the apex info
select * from v$version
I think this will give you the info you are looking for.
select * from apex_release
>1 person found this helpful
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.
Thanks a lot!!!!!!!!!