Column heading is getting truncated
508601Nov 19 2007 — edited Nov 19 2007Hello,
I am trying to display my output in SQLPLUS but my colum heading is getting truncated based on the length of the actual column.
I do << select * from temp_table >>
DATA_MONT,SOURCE_PROD
01-APR-07,00002314401
DATA_MONTH was truncated to DATA_MONT
and SOURCE_PRODUCT was truncated to SOURCE_PROD
What do I need to set to avoid truncating the column headers.
FYI : it is doing the truncate on varchar and data columns. Number columns are not getting truncated !