Sql*plus中, 不允許sql語(yǔ)句中間有空行, 這在從其它地方拷貝腳本到sql*plus中執(zhí)行時(shí)很麻煩. 比如下面的腳本:
select deptno, empno, ename
from emp
where empno = '7788';
如果拷貝到sql*plus中執(zhí)行, 就會(huì)出現(xiàn)錯(cuò)誤:
scott@O9I.US.ORACLE.COM> select deptno, empno, ename
2 from emp
3
where empno = '7788';
SP2-0734: unknown command beginning "where empn..." - rest of line ignored.
原因是sqlplus遇到空行就認(rèn)為是語(yǔ)句結(jié)束了.
其實(shí)要改變這種現(xiàn)象, 只要使用SQLBLANKLINES參數(shù)就可以了.
scott@O9I.US.ORACLE.COM> SET SQLBLANKLINES ON
scott@O9I.US.ORACLE.COM>
scott@O9I.US.ORACLE.COM> select deptno, empno, ename
2 from emp
3
4 where empno = '7788';
DEPTNO EMPNO ENAME
---------- ---------- ----------
20 7788 SCOTT