Oracle exp function numeric overflow error

Question

I'm trying to do something like this in Oracle:

   select exp(300) from dual

And I get numeric overflow error, how can I make exponential from 300 or bigger number, because I have no idea.

Thanks.

Answer 1

exp(300) is 1.942426e+130, which is greater than the range of Oracle's NUMBER datatype - the biggest number you can have in Oracle is: 9.99...9 x 10¹²⁵ with up to 38 significant digits.

So in short, no, you won't be able to calculate exp(300) in Oracle.