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

 

转载于:https://www.cnblogs.com/jasonsun/archive/2010/08/10/1796921.html