Column names display issue in terminal I am using SQL*Plus and connected to the HR schema. 

When I do SELECT * FROM tab; it gave me three column names displayed in different lines.

Is there a way to correct it?
Of course, SQL*Plus does not autoformat your output, but you can do it:

SQL&gt; col tname format a30
SQL&gt; col tabtype format a7
SQL&gt; set numwidh 10

SQL&gt; select * From tab where rownum = 1;

TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
ACCESS$                        TABLE