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
