C.3.1.1 Verifying If You Have a Previous Release of Oracle APEX

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

To verify whether you have a previous release of Oracle APEX:

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

   • On Windows:

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

   • On UNIX and Linux:

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

2. Execute the following command in SQL*Plus:

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