SQL & PL/SQL

Hi,

I'm exporting some data from plsql via plain xml files

(my decimal separator is comma ",", but I don't think it's important)

When I have to export numbers, I just concat the tags with the values.

I thought it was working ok, but the problem is that when the number is, for example, 0.1234 it showed

<value>.1234</value>

instead of :

<value>0,1234</value>

So I worked out this solution:

to_number(myvar, 'FM9999999990D99999')

and it seemed to work, but now, with integer values, it sends a trailing comma, like this:

select '<value>'||to_char(1234, 'FM9999990D999999') ||'</value>' from DUAL;

<value>1234,</value>

I can rtrim the comma, but ...WTF!!