title: need to insert string of data into a table column with a NUMBER datatype
body: <p>In Oracle, I have a table with a column of data type NUMBER. I need to insert a string into a new row I'm about to create. The other rows can certainly remain NUMBERs because usually that's what I need to insert in them. So is there a way to insert a new row with a string sort of like this(this wouldn't work for me)?</p>
  
  <pre><code>INSERT INTO keyboard_learning (emplid,wpm,date_completed,exercise,attempt)
  VALUES (seq_keyboard_learning.nextval,to_char('LEVEL 3'),'14-JUN-2012','Meteor typing blast',1)
  </code></pre>
  
  <p>I want to create a new row where usually I would put a number like for example ' 23 ' in a new row of the WPM column. This time I want to put 'LEVEL 3'instead just the number 23</p>