This discussion is archived
5 Replies Latest reply: Mar 26, 2013 1:41 AM by Tushar Lapani RSS

Determining Oracle Vesion from APEX

Tushar Lapani Newbie
Currently Being Moderated
How can I determine version of oracle database from APEX. Is there any built in table or view is available in APEX? Is it possible from Shared Component?
Thanks.
  • 1. Re: Determining Oracle Vesion from APEX
    scott.wesley Guru
    Currently Being Moderated
    Check out the bottom right of each page in the application builder.
  • 2. Re: Determining Oracle Vesion from APEX
    Logaa Journeyer
    Currently Being Moderated
    Hi,
    Do you need to know db instance details, then check here
    SQL Workshop->Utilities-> About Database->Database Administrator Login -> dba role -> details will display.
    Thanks,
    --Loga                                                                                                                                                                                                                                                                                                                                                                                       
  • 3. Re: Determining Oracle Vesion from APEX
    kvlek Journeyer
    Currently Being Moderated
    Hi

    For db info:
    select * from v$version
    For the apex info
    select * from apex_release
    I think this will give you the info you are looking for.

    Kees Vlek
  • 4. Re: Determining Oracle Vesion from APEX
    fac586 Guru
    Currently Being Moderated
    >

    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:
    select version from product_component_version where product like 'Oracle Database%';
    In PL/SQL there is the <tt>dbms_utility.db_version</tt> API procedure:
    declare
      v varchar2 (20);
      c varchar2 (20);
    begin
      dbms_utility.db_version(v, c);
      dbms_output.put_line(v);
    end;
    /
    I think using the documented API is the way to go.
    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.
  • 5. Re: Determining Oracle Vesion from APEX
    Tushar Lapani Newbie
    Currently Being Moderated
    Thanks a lot!!!!!!!!!

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points