Re: How to suppress the leading space of a number column?

How about:
select col1||col2||col3||col4 from myTable;

hth
wysza

"Dino Hsu" <dino1_nospam_at_ms1.hinet.net> wrote in message news:2r3odtc217ah48bmqnbrosmb3nun99d7qs_at_4ax.com...
| Dear all,
|
| I am very much frustrated by the number formatting of SQL Plus,
| because it always add one more space in front of a number column,
| which is not necessary for me. For example:
|
| <SQL script begin>
| set space 0
| column n1 format 999
| column n3 format 999
| column n5 format 999
| column c2 format a3
| column c4 format a3
| column c6 format a3
|
| select 100 n1, '200' c2, 300 n3, '400' c4, 500 n5, '600' c6 from dual;
| <SQL script end>
|
| <SQL result begin>
| N1C2 N3C4 N5C6
| ---------------------
| 100200 300400 500600
| ^ ^ ^
|
| 1 row selected.1 row selected.
| <SQL result end>
|
| The additional space will cause errors in my interface file (in this
| case, these column are always positive or zero). On the other hand, if
| I change the number formats to 99 instead of 999, the values become
| '###', which means undisplayable. Any comments? Thanks.
|
| Dino
|
  Received on Tue Apr 17 2001 - 06:25:28 CDT