Oracle Apex - Request

About

The request is a system variable initialized:

• with the name of the button when a user clicks.
• or with the fourth parameter of the Apex URL

It will then start the related process.

Articles Related

Management

System Values

Valid Update Request Values: 	SAVE, APPLY CHANGES, UPDATE, UPDATE ROW, CHANGE, APPLY, APPLY%CHANGES%, GET_NEXT%, GET_PREV%
Valid Insert Request Values: 	INSERT, CREATE, CREATE_AGAIN, CREATEAGAIN
Valid Delete Request Values: 	DELETE, REMOVE, DELETE ROW, DROP

Reference

You can reference the REQUEST variable using the syntax:

• Substitution string: &REQUEST.
• PL/SQL: V('REQUEST')
• Bind variable: :REQUEST

Example in SQL:

:REQUEST LIKE ('APPLY_CHANGES%')

Condition

Oracle Apex - Condition (Display, Processing)