SQLPlus Set常用设置

来源：互联网发布：重启后正在准备windows 编辑：程序博客网时间：2024/06/07 06:40

#设置sqlplus输出的最大行宽

SQL> set linesize 140

#col name format a50 ：将列name（字符型）显示最大宽度调整为50个字符

SQL> col name format a50
SQL> select * from v$dbfile;

FILE# NAME
---------- --------------------------------------------------
4 /u01/oracle/oradata/OCP/users01.dbf
3 /u01/oracle/oradata/OCP/undotbs01.dbf
2 /u01/oracle/oradata/OCP/sysaux01.dbf
1 /u01/oracle/oradata/OCP/system01.dbf
5 /u01/oracle/oradata/OCP/example01.dbf

#修改列标题

SQL> col name heading filename
SQL> select * from v$dbfile;

FILE# filename
---------- --------------------------------------------------
4 /u01/oracle/oradata/OCP/users01.dbf
3 /u01/oracle/oradata/OCP/undotbs01.dbf
2 /u01/oracle/oradata/OCP/sysaux01.dbf
1 /u01/oracle/oradata/OCP/system01.dbf
5 /u01/oracle/oradata/OCP/example01.dbf

#输出域标题，缺省为on
SQL> set heading off
SQL> select * from v$dbfile;

4 /u01/oracle/oradata/OCP/users01.dbf
3 /u01/oracle/oradata/OCP/undotbs01.dbf
2 /u01/oracle/oradata/OCP/sysaux01.dbf
1 /u01/oracle/oradata/OCP/system01.dbf
5 /u01/oracle/oradata/OCP/example01.dbf

阅读全文

0 0