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 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.