Wednesday, 20 March 2019

Using TABLE operator with apex_application.g_fxx collections

From Oracle version 12.1 it is possible to use TABLE operator with APEX apex_application.g_fxx collections to get Your data directly into SELECT statement as table.


  • In interactive or classic report define one field as checkbox (APEX_ITEM package)
  • Create new process which executes after submit
  • Inside PLSQL code You can use following SELECT to get checked values

SELECT column_value as vl
FROM table(apex_application.g_f01)
WHERE column_value is not null

Examples and detailed explanation:

No comments:

Post a comment