SQLBL[ANKLINES] {ON|OFF}
控制是否允许在SQL命令中出现空行。默认值为OFF。
![ContractedBlock.gif](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
SQL
>
set
sqlblanklines off
SQL > select *
2 --- 在此直接回车后立即退出到命令提示符下
SQL > set sqlblanklines on
SQL > select *
2 --- 在此直接回车后并不退出。允许出现空行
3
4 from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
SQL > select *
2 --- 在此直接回车后立即退出到命令提示符下
SQL > set sqlblanklines on
SQL > select *
2 --- 在此直接回车后并不退出。允许出现空行
3
4 from dept;
DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON