Previous Next JavaScript must be enabled to correctly display this content

## C.3.1.1 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.

Parent topic: Reverting to a Previous Release After a Failed Upgrade Installation