POWER(47.3616, 27.1261) returns: 2.80403309600359E45 which causes "number precision too large" error in my variable which is defined as NUMBER(20,20).
I've tried ROUNDing and TRUNCing the product, but still get the same long output. The only thing that seems to work is SUBSTR.
Is that the ONLY way to deal with this? It seems like there would be a better way or is there another type I should use these super long decimal results?
SQL> SELECT POWER(47.3616, 27.1261) AS Exp_Val 2 FROM dual;
EXP_VAL  2.8040E+45
SQL> SQL> SELECT ROUND(POWER(47.3616, 27.1261),4) AS Exp_Val 2 FROM dual;
EXP_VAL  2.8040E+45
SQL> SQL> SELECT TRUNC(POWER(47.3616, 27.1261)) AS Exp_Val 2 FROM dual;
EXP_VAL  2.8040E+45
SQL> SELECT SUBSTR(POWER(47.3616, 27.1261),1,6) AS Exp_Val 2 FROM dual;
EXP_VA  2.8040
SQL>
Thank you for any input! Tony
