Oracle Apex - Request

Card Puncher Data Processing

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

Oracle Apex - Condition (Display, Processing)

Oracle Apex Request Expression Condition





Discover More
Card Puncher Data Processing
Oracle Apex - Custom Authentication

Authentication Function Name: my_authentication PL/SQL Code: REQUESTApex URLPage processing section REQUESTApex URL“”page rendering session id To have proper redirection, the login function...
Apex Automatic Dml Item Configuration
Oracle Apex - Simple Form

A simple form (ie not ) A form can be populated either: on load with PL/SQL or with an Automatic Row Fetch Step 1 - Create an HTML region (to serve as a container for your page items)....
Card Puncher Data Processing
Oracle Apex - URL

The format of the APEX URL and URL management. Where: pocserver01:7777...



Share this page:
Follow us:
Task Runner