Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create or replace function p (n number) return number is 
begin 
  return n;
end;
/
select p(+12345678901234567890123456789012345678901234567890) as x from dual union all
select p(-12345678901234567890123456789012345678901234567890) as x from dual union all
select p(+1.2345678901234567890123456789012345678901234567890) as x from dual union all
select p(-1.2345678901234567890123456789012345678901234567890) as x from dual union all
select p(+12345678901234567890123456789012345678.901234567890) as x from dual union all
select p(-12345678901234567890123456789012345678.901234567890) as x from dual union all
select p(+123456789012345678901234567890123456789012345.67890) as x from dual union all
select p(-123456789012345678901234567890123456789012345.67890) as x from dual;


X


12345678901234567890123456789012345678900000000000

-12345678901234567890123456789012345678900000000000

1.23456789012345678901234567890123456789

-1.23456789012345678901234567890123456789

12345678901234567890123456789012345678.9

-12345678901234567890123456789012345678.9

123456789012345678901234567890123456789000000

-123456789012345678901234567890123456789000000