Home -> Usenet -> comp.databases.oracle -> Trailing spaces remove help?

Trailing spaces remove help?

From: ADN communication group <adn_at_kaija.spb.su>
Date: Wed, 10 Feb 1993 07:38:34 GMT
Message-ID: <1993Feb10.073834.3105_at_kaija.spb.su> 






Hello everybody!



I have Oracle V6 running at Unix ISC SysV. I am novice in Oracle.
Please help me with removing trailing spaces in Oracle output.



I have:


Col_1                                           Col_2                Col_3


----------------------------------------------- -------------------- --------


Name_name_name                                  2019                 5
Fa_la_la_la_la_la_la                            987                  0
Etc_etc_etc                                     100201               900


What must I do to get:


Col_1                Col_2  Col_3


-------------------- ------ -----


Name_name_name       2019   5
Fa_la_la_la_la_la_la 987    0
Etc_etc_etc          100201 900





The maximum length of output column must be equal to longest value in it.
Or, If the alias name of the column longer then longest value in that
column, the maxlength of the column should be equal to that alias.



Is there a simple querty to do it.


All suggestions will be appriciated!


Thanks in advance!


--



Nick Maximov


St. Petersburg, Russia
Received on Wed Feb 10 1993 - 08:38:34 CET












Original text of this message