Hi All,
I have a task to round off the Price column in the price_value table upto 2 decimal values.
create table price_value (price number(20,4));
insert into price_value values(5);
insert into price_value values(55);
insert into price_value values(55.5);
insert into price_value values(55.12);
insert into price_value values(55.456);
select * from price_value;
Expected Output
5.00
55.00
55.50
55.12
55.45
Please help me how to do this.
Thanks,