Trailing spaces remove help?
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:
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.
Col_1 Col_2 Col_3
What must I do to get:
----------------------------------------------- -------------------- --------
Name_name_name 2019 5
Fa_la_la_la_la_la_la 987 0
Etc_etc_etc 100201 900
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
Thanks in advance!
--
Nick Maximov
St. Petersburg, Russia
Received on Wed Feb 10 1993 - 08:38:34 CET