Eclipse Data Tools Platform - getting nicer

Did not use to use it since it seemed inferior to more specialised tools. But I can see in Galileo (3.5 that is) it behaves much better and is suitable for many tasks involving just reviewing and/or editing data. Especially not BLOBS - haven't tried out the current DTP support for them though.


In preferences, under General/Data Manegement/SQL Editor on "General" tab you can set what "Execute current text" should mean. I do not like the default "Execute current line" but the other choices "between delimiters" and "between blank lines" are much better. Alt+s in SQL scrapbook and I have my query executed.

FlashGot-like download by means of wget in Opera under Linux

To have Opera behave similar way as Firefox with FlashGot http://flashgot.net/ - that is, to have wget download files:

• Edit ~/.opera/menu/standard_menu_1.ini file (note: Opera must not run!)
  
  
• In section [Link Popup Menu]
  add the following line:
  Item, "Download by wget"="Execute program, "xterm +132 -e wget -P/home/username/downloads","%l""

Inspiration: http://www.linux.com/archive/feature/59457

How to get a value of an XML element from XMLType in Oracle

EXTRACTVALUE method:
EXTRACTVALUE(XMLTYPE_instance,XPath_string) or
EXTRACTVALUE(XMLTYPE_instance,XPath_string, namespace_string)
e.g.

select extractvalue(details, '/SomeDoc/SomeDetail')
from SomeTable