4.5.3.3 Working with Delimited Values

When a page item contains multiple value separated by a delimiter like colon (:) or comma (,) you can use its multiple values in SQL or PL/SQL.

• Working with Delimited Number Values
  To work with delimited number values in SQL or PL/SQL, use the apex_string.split_numbers() function.
• Working with Delimited String Values
  To work delimited values in SQL or PL/SQL, use the apex_string.split() function.