SQLPRE[FIX] {c}
设置SQL*Plus前缀字符。在输入SQL命令或PL/SQL块时可以在一个单独的行上输入一个带有前缀字符的SQL*Plus命令,SQL*Plus将立即执行这个命令并不会影响你正在输入的SQL命令或PL/SQL块。前缀字符必须是一个非数字字符。默认为“#”。
![ContractedBlock.gif](https://images.cnblogs.com/OutliningIndicators/ContractedBlock.gif)
![ExpandedBlockStart.gif](https://images.cnblogs.com/OutliningIndicators/ExpandedBlockStart.gif)
SQL
>
select
*
2 #column DNAME heading DepartmentName
2 #column LOC heading Location
2 from scott.dept;
DEPTNO DepartmentName Location
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON
2 #column DNAME heading DepartmentName
2 #column LOC heading Location
2 from scott.dept;
DEPTNO DepartmentName Location
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON