Oracle APEX

https://docs.oracle.com/en/database/oracle/apex/26.1/htmdb/
Admin
Oracle APEX is an enterprise low-code application platform that enables developers to build...
Tokens:703,785
Snippets:6,746
Trust Score:9.1
Update:1 month ago
Show doc for...
Tokens:
Raw
### 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
```
Tokens:
Raw