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:
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
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.