SQL*Plus (MOSC)

MOSC Banner

get a 0 before the decimal

edited Mar 28, 2012 7:26PM in SQL*Plus (MOSC) 7 commentsAnswered
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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center