Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to trim the extra space on a NUMBER field
Why not post your query, your output and your version of Oracle? All
very helpful to anyone who wants to tackle your question.
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?
>
>
Received on Wed Oct 30 2002 - 19:23:55 CST