title: insert a multiline string in Oracle with sqlplus
body: <p>I have a SQL script that will insert a  long string into a table. The string contains a new line (and this new line is absolutely necessary), so when it is written in a text file, the query is split to multiple lines. Something like:</p>
  
  <pre><code>insert into table(id, string) values (1, 'Line1goesHere 
  
  Line2GoesHere 
  blablablabla
  ');
  </code></pre>
  
  <p>This runs ok in Toad, but when I save this as a .sql file and run it using sqlplus, it considers each line a separate query, meaning that each line will fail (beacuse <code>insert into table(id, string) values (1, 'Line1goesHere</code>, <code>Line2GoesHere</code> aren't well-formated scripts.</p>
  
  <pre><code>SP2-0734: unknown command beginning "Line2GoesHere" - rest of line ignored.
  </code></pre>
  
  <p>Is there a way to fix this?</p>