Being Coldfusion programmer, parsing list value in coldfusion is very simple. If list value is "list1|list2|list3|list4", we can parse with ListToArray in Coldfusion as follow.
<cfset getListDump = ListToArray(MyListValue, "|", true)>
Above coding, we must need to assign true for includeEmptyFields if list value will contain empty. In Oracle, it's touch to parse and we need to write Oracle function.