title: Converting a delimited string (or column) to rows in Oracle using a pre-defined system function
body: <p>A few years ago in Oracle 10 or 9 I used a function which was something like "DBMS_COL_2_VAL" (This is definitely not the right function).</p>
  
  <p>The purpose of this built in function is to convert the provided string to rows based on a specified delimiter.  I know that there are multiple ways of converting a delimited string to rows, but what I looking for is this specific function.</p>
  
  <p>If you can help that would be great.</p>
  
  <p>Please do not provide any solutions with CONNECT, CASE, or REGEX.</p>
  
  <p>Thanks</p>