12c Precision Problem

Question

Hi,

I created a "tablecar" and one columns as "Price NUMBER(25,2)" , car_name varchar2(3 byte).

In Toad;

select * from tablecar;

PriceCar_Name
1341,15abc1402,84def

In 11g shown as;

PriceCar_Name
1341,15abc1402,84def

In 12c shown as;

PriceCar_Name
1341abc1403def

In rpd, typed as double in same system. I do not want to need to change as column properties-> Data Format-> Decimal Places->2 .

If the column build as number(x,2) , report must show what accuately this column created as dataase.

Is there any special settings for this?

Version : Oracle Business Intelligence 12.2.1.2.0

Thank you,

Evren

3506585 · Answer

Hi Gianni, You  are right. Thank you

Gianni Ceresa · Answer

3506585 wrote:In 11g it is not necessary to set this settings.

Are you really sure?

Didn't you just set a system-wide default for that data type in your 11g?

Because out of the box I'm kind of sure 11g always display numbers without any decimal ...

Martin van Donselaar · Answer

You will have to apply a format, Like Robert already said, this can be done in answers: