title: Insert empty string in Oracle
body: <p>I'm trying to insert an empty string in a non-nullable column in Oracle but fails. Here's the case:</p>
  
  <pre><code>create table trademark (
    name varchar2(100) not null
  );
  
  insert into trademark (name) values ('Kodak');
  
  insert into trademark (name) values (' '); -- one space
  
  insert into trademark (name) values (''); -- empty string
  Error: ORA-01400: cannot insert NULL into ("USER1"."TRADEMARK"."NAME")
  </code></pre>
  
  <p>What am I doing wrong?</p>