Hi,
I need to convert a whole number to decimal of 2 precision and insert into table where the column data type is number.
For eg :
insert into Table(balance)
select amount*rate from Master_Table;
Here the data type of balance column is Number. Is there a way to round the result value which is whole number to 2 decimal precision and if there is no whole number just round it to 2 decimal precision.
rate column is also Number(14,2) where values will be like 1.2356, 150.22 e.t.c
Output:
Table
Balance
1213.00
12311.00
-1111.00
-11.00
It can be using to_char but since my datatype of balance of target table is Number i dont want to change it.