The width of the column NAME is 50 positions. How do I specify that I
just want the column to be for example 20 positions wide on the output
select name, age, salary
I have tried
select substr(name,1,20), age, salary
but that does'n work.
I have also tried options linesize=200;
but that seems to make the column NAME even wider.
Does anyone have any suggestions how to code it ?