how to put 0,001 into item and not .001

[LimonaM]

how to put 0,001 into item and not .001?

Where can i and how describe mask for numbers so the first zero won't be erased?

 

[LimonaM]

Item tyoe is char, because there aren't allways numbers. I just need the leading null(0).

 

[sem]

0D990

 

[Mockenrue]

Something like:

column_char := to_char( p_number
, '99999990D000'
, 'NLS_NUMERIC_CHARACTERS = '',.'''
);

Arthur