Most efficient way to parse a Comma Separated list in ApEx
<p>I am still working on my first solo Oracle ApEx(Application Express) application, so I am sure that this will be old hat for some of you. I tried to look up what I want to do, but I am not sure what to even look up. If there is already a thread that answers this, then I apologize for duplication, but I have searched here for about two hours trying to figure this out.</p>

<p>I am open minded to a solution since I have not already built anything for this part of the application yet, so I am not locked into one set way. If there is a better way, please let me know.</p>

<p>I want to obtain a comma separated (or semi-colon, or colon separated) list from the user. I then want to take that data and write it to a table with each value in its own row.</p>

<p>Example of input:</p>

<pre><code>X12345678, X22345678, X32345678 (and so on)
</code></pre>

<p>The numbers that are input will then be looked up on a different table because we use non-identifying PIDM numbers (Anyone that has used Ellucian's Banner will understand). This select statement is crazy simple to retrieve this number: </p>

<pre><code>Select spriden_pidm 
from spriden 
where spriden_change_ind is null
  and spriden_id = :P5_STU_ID
</code></pre>

<p>Then, it will be stored in a table thusly:</p>

<p>Example of data storage:</p>

<pre><code>   ID      |  Semester  |  Creating User  | Created Date | Data Origin
012345678  |   201640   |      JDOE1      |    sysdate   |  ApEx : 130
022345678  |   201640   |      JDOE1      |    sysdate   |  ApEx : 130
</code></pre>

<p>And so forth.</p>

<p>Question 1: I am presuming that a loop will be the best way to accomplish this using regular expressions. Would that be a correct presumption?</p>

<p>Question 2: Does ApEx already have something built in that would process this better and/or faster?</p>

<p>ApEx version 5.0, Oracle 12c</p>