Total Eclipse of the Heart
99.99% times I do not like to re-post youtube video links but this time I just have to spread some genius rework of a music video. And what’s more — song title is “Total Eclipse of the Heart”. So let’s use the video to find some out-of-the-box inspiration for our Eclipse platform future!
Thanks for watching! Do you see a message related to the Eclipse Platform?
Changing number scale for Oracle NUMBER columns
Whenever you try to change your NUMBER column to more specific scale like NUMBER(10,2) you end up with an error message:
SQL Error: ORA-01440: column to be modified must be empty to decrease precision or scale
There is a way out of this but it is a bit hacky. Let me know if there is a more elegant solution!
Following example also takes care of the situation when your column is not nullable.
-
ALTER TABLE MYTABLE ADD AMOUNT_TEMP NUMBER;
-
UPDATE MYTABLE SET AMOUNT_TEMP = AMOUNT;
-
ALTER TABLE MYTABLE MODIFY AMOUNT NULL;
-
UPDATE MYTABLE SET AMOUNT=NULL;
-
ALTER TABLE MYTABLE MODIFY AMOUNT number(10,2);
-
UPDATE MYTABLE SET AMOUNT=AMOUNT_TEMP;
-
ALTER TABLE MYTABLE MODIFY AMOUNT NOT NULL;
-
ALTER TABLE MYTABLE DROP COLUMN AMOUNT_TEMP;
Take care!
Quick hint: Ignore bin, target, build etc dirs in Eclipse CVS and SVN Synchronize View
Directory ignore feature for svn and cvs in Eclipse Synchronize View is located in a straightforward place but still from time to time we tend to forget. I keep looking at SVN settings and synchronize View Menu but it is not there.
Here it comes:
Window->Preferences->Team->Ignored Resources
Faster is to simply type "ignored" into preferences quick search!
Here you can add patterns like "bin", "build", "target" etc so these will be ignored.
Please be aware that this kind of ignore patterns are not conceptually correct -- ignored resources should be configured at the svn repository meta-info level!
No, Cancel, Yes?
New Eclipse 3.5M7 provides an interesting approach for confirmation dialogs. Previous "Yes, No, Cancel" has been replaced with "No, Cancel, Yes" options.
I wonder what is the reasoning behind it.. Read more (including screenshots) at Ivar blog.
MySQL and Oracle — founders take
Nice reading about MySQL future at Oracle is available at Michael Widenius blog. He is the founder of MySQL, was involved in successfully transferring MySQL business to Sun and left the company in the beginning of 2009.
