tag:blogger.com,1999:blog-13265058.post3762460394035318566..comments2023-10-28T23:33:56.980+11:00Comments on Sydney Oracle Lab: A quick quiz for a Friday.SydOraclehttp://www.blogger.com/profile/08828771074492585943noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-13265058.post-62994349661873007392010-06-17T23:24:39.931+10:002010-06-17T23:24:39.931+10:00Breaks some dates, too
select to_date(TO_NUMBER(&...Breaks some dates, too<br /><br />select to_date(TO_NUMBER('9E9'),'j') from dual;<br /><br />ORA-01854: julian date must be between 1 and 5373484Scott Wesleyhttps://www.blogger.com/profile/18106937181788036683noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-74936000737036032822010-05-29T04:38:08.844+10:002010-05-29T04:38:08.844+10:00In MySQL too ;)
mysql> select 9e9;
+----------...In MySQL too ;)<br /><br />mysql> select 9e9;<br />+------------+<br />| 9e9 |<br />+------------+<br />| 9000000000 |<br />+------------+<br />1 row in set (0.01 sec)<br /><br />mysql> <br /><br />RachidAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-13265058.post-39692689673704090822010-05-28T19:15:11.364+10:002010-05-28T19:15:11.364+10:00Another quick one:
1* select exp('999') ...Another quick one:<br /> 1* select exp('999') from dual<br />SQL> /<br />select exp('999') from dual<br /> *<br />ERROR at line 1:<br />ORA-01426: numeric overflow<br /><br />;)Noonshttps://www.blogger.com/profile/04285930853937157148noreply@blogger.comtag:blogger.com,1999:blog-13265058.post-4089095115006359572010-05-28T19:05:26.734+10:002010-05-28T19:05:26.734+10:00infinite?
select power(
to_number('999'...infinite?<br /><br /><br />select power(<br /> to_number('999'),<br /> to_number('999')) <br />from dual;<br />SQL> /<br /> *<br />ERROR at line 1:<br />ORA-01426: numeric overflow<br /><br /><br />;)Noonshttps://www.blogger.com/profile/04285930853937157148noreply@blogger.com