title: Splitting comma separated string in a PL/SQL stored proc
body: <p>I've CSV string 100.01,200.02,300.03 which I need to pass to a PL/SQL stored procedure in Oracle.
  Inside the proc,I need to insert these values in a Number column in the table.</p>
  
  <p>For this, I got a working approach from over here:</p>
  
  <p><a href="https://stackoverflow.com/questions/1089508/how-to-best-split-csv-strings-in-oracle-9i">How to best split csv strings in oracle 9i</a></p>
  
  <p>[2) Using SQL's connect by level.].</p>
  
  <p>Now,I've another requirement.
  I need to pass 2 CSV strings[equal in length] as input to PL/SQL stored proc.And, I need to break this string and insert each value from two CSV strings into two different columns in the table.Could you please let me know how to go about it?</p>
  
  <p>Example of CSV inputs:
  mystring varchar2(2000):='0.75, 0.64, 0.56, 0.45';</p>
  
  <p>myAmount varchar2(2000):= '0.25, 0.5, 0.65, 0.8';</p>
  
  <p>myString values would go into Column A and myAmount values into Column B in the table.</p>
  
  <p>Could you please let me know how to achieve this?</p>
  
  <p>Thanks.</p>