5 Replies Latest reply: Mar 26, 2013 3:41 AM by Tushar Lapani RSS

    Determining Oracle Vesion from APEX

    Tushar Lapani
      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
          Check out the bottom right of each page in the application builder.
          • 2. Re: Determining Oracle Vesion from APEX
            Logaa
            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
              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
                >

                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
                  Thanks a lot!!!!!!!!!