### Original Friendly URL Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/understanding-friendly-url-syntax.html Example of an original Friendly URL before customization. The path_prefix is 'example', app_alias is '355', and page_alias is '2'. ```text http://hostname:port/ords/r/example/355/2?session=13766599855150 ``` -------------------------------- ### Installer Session Attributes Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/correlating-apex-sessions-to-database-sessions.html Expressions used by APEX installation scripts to set session attributes during installation or upgrades. ```sql 'APEX ' || install-type || ' PHASE ' || phase ``` ```sql 'upgrade' 'recompiling' ``` -------------------------------- ### File Directory and Name Examples Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/editing-plug-ins.html Examples of directory paths and file names used when creating files for plug-ins. ```text css ``` ```text css/images ``` ```text script.js ``` -------------------------------- ### Navigate to Page with REQUEST using f?p syntax Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/using-available-built-in-substitution-strings.html Example of using the f?p syntax to navigate to application 100, page 1, while setting the REQUEST value to GO. ```text f?p=100:1:&APP_SESSION.:GO ``` -------------------------------- ### f?p URL Syntax Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/about-publishing-an-application-url.html An example of the traditional f?p URL syntax including the session number, followed by the simplified version for user access. ```text http://apex.somewhere.com/ords/f?p=11563:1:3397731373043366363 ``` ```text http://apex.somewhere.com/pls/apex/f?p=11563:1 ``` -------------------------------- ### PL/SQL Expression Attribute Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/editing-plug-ins.html An example of a PL/SQL expression used as a plug-in attribute. ```sql case when :P7_CATEGORY='computer' then true else false end ``` -------------------------------- ### f?p URL Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/understanding-legacy-url-syntax.html Concrete example of an f?p URL: https://hostname:port/ords/f?p=392:3:13766599855150. The example indicates application ID 392, page number 3, and session number 13766599855150. ```text https://hostname:port/ords/f?p=392:3:13766599855150 ``` -------------------------------- ### APP_ALIAS in f?p Syntax Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/using-available-built-in-substitution-strings.html Example of using APP_ALIAS in f?p syntax to run an application by its alias. ```text f?p=ABC:1:&APP_SESSION. ``` -------------------------------- ### Friendly URL Syntax Example Source: https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/about-publishing-an-application-url.html An example of a full Friendly URL including the session ID, followed by the simplified version for user access. ```text http://apex.somewhere.com/ords/example/r/hr-app/update-employees?session=13766599855150 ``` ```text http://apex.somewhere.com/ords/example/r/hr-app/update-employees ```