Pra saber port, url, etc.
select workspace, workspace_id from apex_workspaces;
select workspace, view_date, seconds_ago from apex_workspace_activity_log order by 2 desc;
select APEX_UTIL.HOST_URL('SCRIPT') from dual;
declare
l_host_url varchar2(4000);
l_url varchar2(4000);
l_application varchar2(30) := 'f?p=100:1';
l_email_body varchar2(32000);
begin
l_host_url := apex_util.host_url('SCRIPT');
l_url := l_host_url||l_application;
l_email_body := 'The URL to the application is: '||l_url;
dbms_output.put_line(l_url);
dbms_output.put_line(l_email_body);
end;
SELECT DBMS_XDB.GETHTTPPORT FROM DUAL;
select dbms_xdb.gethttpport as "HTTP-Port", dbms_xdb.getftpport as "FTP-Port" from dual;