How do I get SQL*Plus to create views / tables with a blank line in the middle of the create statement?

Question

I wish to create some views using SQL*Plus via script, but seem to hit a problem if a developer has placed a blank line mid statement. The following statement works fine in TOAD / PL/SQL developer etc, but fails in SQL*Plus. (This is usually scripted, but entering it manually gives exactly the same error)

Can anyone tell me why / how to stop it?

CREATE VIEW bob
AS
SELECT *

FROM DUAL;

With SQL*Plus output

SQL> CREATE VIEW bob
  2  AS
  3  SELECT *
  4
SQL> FROM DUAL;
SP2-0042: unknown command "FROM DUAL" - rest of line ignored.

Answer 1

Hi Martin,

You would use the SET SQLBLANKLINES command:

SQL> SET SQLBLANKLINES on
SQL>
SQL> CREATE VIEW bob
  2  AS
  3  SELECT *
  4  
  5  FROM DUAL;

View created