I am a proud Oracle developer and this is my blog. My website is here This blog is OPINION, SUGGESTION and DEBATE. Please correct anything I write that is misleading.
infinite?select power( to_number('999'), to_number('999')) from dual;SQL> / *ERROR at line 1:ORA-01426: numeric overflow;)
Another quick one: 1* select exp('999') from dualSQL> /select exp('999') from dual *ERROR at line 1:ORA-01426: numeric overflow;)
In MySQL too ;)mysql> select 9e9;+------------+| 9e9 |+------------+| 9000000000 |+------------+1 row in set (0.01 sec)mysql> Rachid
Breaks some dates, tooselect to_date(TO_NUMBER('9E9'),'j') from dual;ORA-01854: julian date must be between 1 and 5373484
Post a Comment
4 comments:
infinite?
select power(
to_number('999'),
to_number('999'))
from dual;
SQL> /
*
ERROR at line 1:
ORA-01426: numeric overflow
;)
Another quick one:
1* select exp('999') from dual
SQL> /
select exp('999') from dual
*
ERROR at line 1:
ORA-01426: numeric overflow
;)
In MySQL too ;)
mysql> select 9e9;
+------------+
| 9e9 |
+------------+
| 9000000000 |
+------------+
1 row in set (0.01 sec)
mysql>
Rachid
Breaks some dates, too
select to_date(TO_NUMBER('9E9'),'j') from dual;
ORA-01854: julian date must be between 1 and 5373484
Post a Comment