SQL*Plus 系统变量之45 - SQLCO[NTINUE]

SQLCO[NTINUE] {text}

设置当使用连接符（-）把一个SQL*Plus命令分成多行输入时的提示文本。默认为“>”。

 

SQL> set sqlcontinue 'Enter the next line>'

SQL> column DNAME -

Enter the next line>heading DepartmentName

SQL> select deptno,dname from scott.dept;

 

    DEPTNO DepartmentName

---------- --------------

        10 ACCOUNTING

        20 RESEARCH

        30 SALES

        40 OPERATIONS