如何更清晰地显示表数据。在oracle sqlplus中 [英] how to display table data more clearly. in oracle sqlplus

问题描述

以下是sqlplus显示我的表格数据的方式：

alt text http://img683.imageshack.us/img683/5512/tabless.png

但我想显示为

 名称|地址| 
 ------- + --------------- + 
 name1 | address1 | 
 name2 | address2 | 
 name3 | address3 | 
  

解决方案

 设置行256 
在
上设置trimout关闭
  pre> 
 
 
如果您已安装帮助信息，请查看帮助集。然后选择名称，地址而不是 select * 如果你真的只想要这两列。
 
Here is the way sqlplus displays my table data:

alt text http://img683.imageshack.us/img683/5512/tabless.png

but I want to show them as 
Name   |    Address    |
-------+---------------+
name1  |    address1   |
name2  |    address2   |
name3  |    address3   |

解决方案
I usually start with something like:
set lines 256
set trimout on
set tab off
Have a look at help set if you have the help information installed. And then select name,address rather than select * if you really only want those two columns.

                        
这篇关于如何更清晰地显示表数据。在oracle sqlplus中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！