Re: Trailing spaces remove help?
Date: Wed, 10 Feb 93 14:19:15 GMT
Message-ID: <1993Feb10.141915.24245_at_netnews.whoi.edu>
In article <1993Feb10.073834.3105_at_kaija.spb.su> adn_at_kaija.spb.su (ADN communication group) writes:
>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
You could try using the rtrim to remove trailing blanks eg.
rtrim(Col_1,' ') Received on Wed Feb 10 1993 - 15:19:15 CET