After months of harassment between Oracle and Europe Commission, the deals got approved by the European Commission.
Still MySQL founder Monty Widenius wants to have Russia and China reject the deal to save the future of MySQL… This will delay the deals further. Good for IBM, bad for Oracle !
Do you user NUMBER or NUMBER(p,s) for your datatypes?
I posted last year about 1!=1
Today I realized this could be solved with the scale 🙂
SQL> drop table lsc_t
SQL> create table lsc_t(x number, y number(*,6))
SQL> insert into lsc_t values (1/3*3,1/3*3)
1 row created.
SQL> select * from lsc_t where x=1
no rows selected.
SQL> select * from lsc_t where y=1
So if you have amounts in US$ or GB£ or CHF, do not use NUMBER, use NUMBER(*,6) or NUMBER(*,2) or whatever is relevant to your business!
It is quite a while I have not posted anything of interest, I pretty apologize to my faithful readers… the reason for being offline are multiple, one of them, I cannot access my blog from my workplace yet.
Ok, the last hint from my dba regarding Oracle Support :
If flash really drives you nuts, go for html : supporthtml.oracle.com