line breaks in sqlplus [duplicate]

Question

we develop the sql scripts in oracle sql developer and in production dba execute the same in oracle sql plus.

The problem is if we insert a line break

  Create table test(

  text number(10)

The line break is causing the scripts to fail, do you know how to fix this in sqlplus?

Also we generate the scripts using liquibase, so any ways to address this?

Answer 1

Try adding:

set sqlblanklines on

to the start of your sql script.