oracle sqlplus如何更清晰的显示表数据 [英] How to display table data more clearly in oracle sqlplus

问题描述

我希望能够以漂亮的方式显示选择的结果数据，而不是其他列下的所有列.

I want to be able to display the resulting data from a select in a pretty way, not all columns under others.

这里是 sqlplus 显示我的表数据的方式:

Here is the way sqlplus displays my table data:

但我想将它们显示为:

Name   |    Address    |    Phone    |
-------+---------------+-------------+
name1  |    address1   |    phone1   |
name2  |    address2   |    phone2   |
name3  |    address3   |    phone3   |

不是每一列都在另一列之下

Not each column under the other

推荐答案

我通常从以下内容开始:

I usually start with something like:

set lines 256
set trimout on
set tab off

如果您安装了帮助信息，请查看help set.然后 select name,address 而不是 select * 如果你真的只想要这两列.

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屋！