When working with scripts in Toad's editor, if running as F5, the script results are returned. If there is a varchar or char who's header is longer than the noted size of the value, the header will be truncated to fit that size.
i.e. a column is set as CHAR(2) and the column name is "STATE". When the data is returned in script, it displays as
ST
--
CA
What would be better is
STATE
-----
CA
Is there a setting in Toad that help adjust for this? If running a query as F9 run as statement, the grid does not have this problem, and the full column name is displayed. Sizing of the grid's column may be an issue but that can be adjusted and Toad has grid options for sizing that can be applied for that.
Setting determined by Oracle. If the header is too long, Oracle with truncate this.
Apply the SQL Plus command to address this. Further details of the command and syntax included:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch12013.htm#BACHCABF
Syntax
COL[UMN] [{column | expr} [option ...]]
