Oracle APEX Version
set linesize 300
col version_no for a20
col api_compatibility for a30
col patch_applied for a30
select * from apex_release;
VERSION_NO API_COMPATIBILITY PATCH_APPLIED
-------------------- ------------------------------ ------------------------------
5.0.3.00.03 2013.01.01
col pdb_name for a25
select p.pdb_name, r.version, r.status from sys.dba_pdbs p, sys.cdb_registry r
where p.pdb_id = r.con_id
and r.comp_id = 'APEX'
order by 1;
------------------------- ------------------------------ --------------------------------------------
ORCL 5.0.3.00.03 VALID
set linesize 300
col username for a30
select USERNAME,DEFAULT_TABLESPACE,TEMPORARY_TABLESPACE from cdb_users where USERNAME like 'APEX%';
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE
------------------------------ ------------------------------ ------------------------------
APEX_REST_PUBLIC_USER USERS TEMP
APEX_PUBLIC_USER USERS TEMP
APEX_LISTENER USERS TEMP
APEX_050000 SYSAUX TEMP
col oracle_maintained for a18
select username, default_tablespace, temporary_tablespace, profile, oracle_maintained
from dba_users
where regexp_like(username,'^(APEX_|ORDS_)');SQL> SQL> SQL> 2 3
USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE PROFILE ORACLE_MAINTAINED
------------------------------ ------------------------------ ------------------------------ -------------------- ------------------
APEX_REST_PUBLIC_USER USERS TEMP DEFAULT N
APEX_PUBLIC_USER USERS TEMP DEFAULT Y
APEX_LISTENER USERS TEMP DEFAULT N
ORDS_PUBLIC_USER USERS TEMP DEFAULT Y
APEX_050000 SYSAUX TEMP DEFAULT Y
ORDS_METADATA SYSAUX TEMP DEFAULT Y
6 rows selected.
