Posted By: Anonymous
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.