Hello everyone I have VMware which I used to practice Oracle APEX 5.0 , currently I'm not able to login to Oracle APEX because I don't know my worksapce name and the username to login to apex, I still have access to Oracle database through the system user , I just need a query that allow me to retrieve the Oracle APEX username and the workspace name ?
As of workspaces: when you query list of users:
SQL> select * From all_users;
USERNAME USER_ID CREATED
------------------------------ ---------- ----------
XS$NULL 2147483638 29.05.2014
MIKE 71 30.03.2018
SCOTT 66 03.03.2018
APEX_040000 47 29.05.2014 --> this
APEX_PUBLIC_USER 45 29.05.2014
you'll see the APEX user; on my XE database, it is Apex 4.0 that installs by default.
Once you find the APEX_ username, find all workspaces as
SQL> select workspace from apex_040000.apex_workspaces;
WORKSPACE
---------------------------------------------------------
HR
INTERNAL
SQL>
As of usernames, try with
SQL> select user_name from apex_040000.wwv_flow_fnd_user;
USER_NAME
---------------------------------------------------------
ADMIN
HR
SQL>