This plugin create a multi row APEX item.
Import item_type_plugin_mesquitarod_multirow_item.sql file into your application.
- Create an item
- Change the item type to APEX MultiRow Item Plugin[Plug-In].
- Limit: limit the number of items.
- Limit Reached Message: Custom message to show when the limit is reached
- Add Item Icon: Add item buttom icon
- Remove Item Icon: Remove item buttom icon
- The change event dynamic action can be used when add/remove a new item.
Use APEX_STRING (SPLIT/SHUFFLE) to separate or regroup the colon separated values
Documentation: https://docs.oracle.com/en/database/oracle/application-express/19.1/aeapi/APEX_STRING.html#GUID-CAFD987C-7382-4F0F-8CB9-1D3BD05F054A
select column_value From TABLE(apex_string.split('1:2:3',':'));