Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t (n number)
insert into t(n) values (3.14159265358979)
1 rows affected

select * from t

N

3.14159265358979

create table t2 (n number(5))
insert into t2(n) values (3.14159265358979)
1 rows affected

select * from t2

N

3