title: Insert some spaces into a string oracle database
body: <p>I have a oracle table called <code>MYTABLE</code> , with a <code>prog_model</code> column. 
  I am trying the <code>CASE</code> (if oracle) to insert some spaces into my <code>prog_model</code> depending of the string length. </p>
  
  <p>My issue is that I'm getting <code>ORA-00936 error missing expression ligne 3 c18</code> I have no idea where it comes from being a super noob in SQL, any ideas?</p>
  
  <p>Here is my .sql : </p>
  
  <pre><code>SELECT prog_model,
    CASE Length(prog_model)
      WHEN 11 THEN Insert('   ',2,3,prog_model)
      WHEN 12 THEN Insert('  ',2,3,prog_model)
      WHEN 13 THEN Insert(' ',2,3,prog_model)
    END
  FROM MYTABLE;
  </code></pre>
  
  <p>EDIT: </p>
  
  <p>Basically in <code>prog_model</code> I <strong>always</strong> have a string from 11 to 14 characters : </p>
  
  <p>if 11 chars , "ABCEFGHIJKL" --> "ABC_ _ _EFGHIKL"</p>
  
  <p>if 12 chars , "ABCEFGHIJKLM" --> "ABC_ _EFGHIJKLM"</p>