title: How to best split csv strings in oracle 9i
body: <p>I want to be able to split csv strings in Oracle 9i</p>
  
  <p>I've read the following article
  <a href="http://www.oappssurd.com/2009/03/string-split-in-oracle.html" rel="noreferrer">http://www.oappssurd.com/2009/03/string-split-in-oracle.html</a></p>
  
  <p>But I didn't understand how to make this work. 
  Here are some of my questions pertaining to it</p>
  
  <ol>
  <li>Would this work in Oracle 9i, if not, why not?</li>
  <li>Is there a better way of going about splitting csv strings then the solution presented above?</li>
  <li>Do I need to create a new type?  If so, do I need specific privilages for that?</li>
  <li>Can I declare the type w/in the function?</li>
  </ol>