get a 0 before the decimal
A table contains field number(8,3) with value "0,845", if I create a statement with SQLPLUS sees it as ",845". We don´t see the integer part. Only occurs when the integer part is the number 0. If the integer is a number other than zero works fine.
If I make the query through a program like Toad or SQL Developer I can see it well: "0,845", but the same query in sqlplus I don´t see integer part when is 0: ",845". I need to see zero because I have ETL tool that moves data into a DB2 database, but this field moves decimal like integer when integer part is zero: "845".
If I make the query through a program like Toad or SQL Developer I can see it well: "0,845", but the same query in sqlplus I don´t see integer part when is 0: ",845". I need to see zero because I have ETL tool that moves data into a DB2 database, but this field moves decimal like integer when integer part is zero: "845".
0