Re: How to trim the extra space on a NUMBER field

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Thu, 31 Oct 2002 17:01:19 GMT
Message-ID: <zldw9.1944$z33.118798447@newssvr21.news.prodigy.com>

kat398_at_yahoo.com wrote:
> i have this query that select a number field and a char field into a
> text file. i am having a lot of extra spaces after the number column.
>
> i tried trim(x), trim(to_char(x)), .... all these methods and still
> couldn't get rid of the extra space, can anyone help please?
If you are talking about the space between columns in SQL*Plus output, you can eliminate it by typing the following at the prompt:

set colsep "" Received on Thu Oct 31 2002 - 11:01:19 CST