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.