Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to trim the extra space on a NUMBER field
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:15:54 CST