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.

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


Powered by ComboStrap