Differences

This shows you the differences between two versions of the page.

oracle:insert_empty_string_to_fk_column [August 30, 2012 11:31 am]
sqlines
oracle:insert_empty_string_to_fk_column [August 30, 2012 11:33 am] (current)
sqlines
Line 122: Line 122:
Now you can use empty string in the INSERT statement, and no error is raised: Now you can use empty string in the INSERT statement, and no error is raised:
-<code>+<code sql>
  INSERT INTO cities VALUES ('Greenwood' , '');   INSERT INTO cities VALUES ('Greenwood' , '');
  # 1 row(s) affected   # 1 row(s) affected