What integer base Oracle operates 2

[dbalearner]

Can you please tell me what integer base Oracle operates. For example is this unsigned integer?

With UNSIGNED INTEGER you have a max value of 4294967295. However, if I perform the following maths, Oracle does not seem to mind!

select 4294967295 * 4294967295 from dual;

4294967295*4294967295
---------------------
1.8447E+19

Thanks

 

[Dagon]

I think Oracle will implicitly convert the result to NUMBER, which has a much higher specification.

Retired (not by choice) Oracle contractor.

 

[Thargy]

Yes,

Dagon is correct, an integer is (annoyingly) automatically converted to a number (38,0).

Regards

T