title: How to insert multiple values in one column of type number in oracle?
body: <p>I have table like</p>
  
  <pre><code>CREATE TABLE TEMP_TABLE  
  ( 
    temp_acct number(10) NOT NULL, 
    temp_code varchar2(250),
    temp_bal number(10,2),
    CONSTRAINT TEMP_TABLE_PK PRIMARY KEY(temp_acct)   
  );
  </code></pre>
  
  <p>Is it possible to insert multiple values into column temp_bal in one row something like below,I know the syntax is incorrect but is there any way? </p>
  
  <pre><code>INTO TEMP_TABLE (temp_acct, temp_code, temp_bal) 
  VALUES (1000, 'code100, code101, code102, code103', '1000.00,2000.00,3000.00');
  </code></pre>