showing only one column in each row, Sqlplus

Question

I am trying to display tables in Oracle properly, but it only shows one column each row.

    SQL> select * from Manager;

FAMILYNAME
--------------------------------------------------
PERSONALNAME
--------------------------------------------------
    SALARY
----------
Sung
Sam
     56000

Smith
Darwin
     54000

P. Fries
Chris
     63000

Williams
Sean
     43000

I tried to adjust linesize and pagesize, but it doesn't help. Is there anyway that I can let it print table properly?

Answer 1

Yes; specify column format, e.g.

col familyname format a15
col personalname format a15

Then run the select statement again.