sqlplus中，设置命令，允许语句中有空白行

通常执行以下语句会出错

1 sql>select * from

2

3 dual;

SP2-0042: unknown command “FROM DUAL” - rest of line ignored.

 

执行以下语句可解决问题

 

 SQL> SET SQLBLANKLINES ON
     SQL> SELECT *
        2  
        3  FROM dual;

     D
     -
     X

     1 row selected.