SQL output different than the code?

Question

I'm writing an SQL code and running in an SSH secure shell client and here's the output after running the code:

SQL> SELECT SalesRepLName || ' , ' || SalesRepFName AS SalesRep_Name,
  2  SalesRepID AS Sales_Rep_ID, SalesRep.CommClass AS Commission_Class, CommRate AS Commission_Rate
  3   FROM SalesRep_mys SalesRep, Commission_mys Com
  4   WHERE SalesRep.CommClass = Com.CommClass
  5  ORDER BY SalesRepLName;

SALESREP_NAME                               SALES_REP_ID C COMMISSION_RATE
------------------------------------------- ------------ - ---------------
Anderson , Mark                                       21 C             .05
Day , Sara                                            14 Z               0
Hayes , Jennie                                        23 D             .03
Jackson , Bob                                         20 B             .08
Jones , Alice                                         10 A              .1
Moore , Micah                                         22 Z               0
Price , Kay                                            8 C             .05
Taylor , Greg                                         12 B             .08

It's suppose to output the full names like SalesRepID, SalesRep_name, etc..but for the commission class, (the one with letter values) it doesn't print the full category name..? How do fix it so it shows Commission_Class?

Look [here](http://stackoverflow.com/q/7384789/1847592) – Egor Skriptunoff May 10 '15 at 19:52 — Egor Skriptunoff, May 10 '15 at 19:52
You're running this in SQL\*Plus, right? – Alex Poole May 10 '15 at 19:52 — Alex Poole, May 10 '15 at 19:52
Yeah it's in sqlplus – LegendofLegends May 10 '15 at 19:53 — LegendofLegends, May 10 '15 at 19:53

score 1 · Answer 1 · answered May 10 '15 at 19:56

You can override the default column width, which is based on the data type, with the COLUMN command. In this case, before running the query:

column commission_class format a16

SQL output different than the code?

1 Answers1