Hi,
I am facing a problem in one of my update queries.
There is a column I am updating whose datatype is NUMBER(9,5). So it can hold 5 places after decimal, and 4 before decimal.

I am using a round function, so that takes care of places after decimal.
But for some of the records the value is getting computed as say 123546.12345, and so i am getting -1438 overflow error while updating.

I want a quick way (or function) to just get rid of the extra digits before decimal point in such cases.

So, in the example above, I want the output as 1235.12345
Please suggest a suitable way. Thanks!

create table t (
  c1 number ( 9, 5 )
);

alter table t 
  modify c1 number ( 38, 5 );