How to display table data more clearly in oracle sqlplus

Nubkadiya picture Nubkadiya · Jun 9, 2010 · Viewed 193.1k times · Source

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

Here is the way sqlplus displays my table data:

enter image description here

But I want to show them as:

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

Not each column under the other

Answer

Alex Poole picture Alex Poole · Jun 9, 2010

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.