Verifying If You Have a Previous Release of APEX

Run a query to verify if you have previous release of Oracle APEX.

To verify whether you have a previous release of APEX:

1. Start SQLcl and connect to the database where APEX is installed as SYS specifying the SYSDBA role. For example:

   • On Windows:

     <SYSTEM_DRIVE>:\ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: <SYS_password>

   • On UNIX and Linux:

     $ sql /nolog
     SQL> CONNECT SYS as SYSDBA
     Enter password: <SYS_password>

2. Execute the following command in SQLcl:

   select username from dba_users
       where regexp_like(username,'(FLOWS|APEX)_\d{6}')
           and username <> (select table_owner from all_synonyms
           where synonym_name = 'WWV_FLOW'
           and owner = 'PUBLIC')

   If the query above returns any rows, the database contains a previous release of APEX.