Here is an example of an Oracle SQL query to find the Oracle Apex port number.

Find Oracle Apex Port

You can find the Oracle Apex port number using the dbms_xdb.gethttpport() function. Below is an example:

select dbms_xdb.gethttpport from dual;

The output will be the Oracle Apex port number if installed and set.

To set the Oracle Apex port number, use the following command:

exec dbms_xdb.sethttpport('8081');
commit;