select to_char(cast (0.008499 as number(38,8)),'0.99999999') from dual; basically, use the number-format as the 2nd parameter on the to_char function.
Mike On Wed, Mar 16, 2011 at 11:39 AM, teo <teomana...@gmail.com> wrote: > Hi everyone, > > I have a table with NUMBER(38,8) column named PRICE. Below there are > some values of this table. > > 0,008499 > 0,01795 > 0,0539 > 0,1078 > 0,0082 > 0,01366667 > 0,00969 > > I need to concat this values with a text. I use to_char(PRICE) || 'A' > the result is like below. Bu as you can see there are no zero (0) How > can i concat this values exactly? > > ,008499A > ,01795A > ,0539A > ,1078A > ,0082A > ,01366667A > ,00969A > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to Oracle-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
