Use Productivity Tool : StrokeIt !!!

While working on various windows tired of minimizing, opening, doing various operations.
Now time to move on to StrokeIt - Mouse Gestures for Windows. : http://www.tcbmi.com/strokeit/

Want to download StrokeIt, use the following link:
http://www.tcbmi.com/strokeit/downloads.shtml

It is also FUN to use this tool using your mouse :)

To get more information about how to use and other details, check out following link:
http://www.tcbmi.com/strokeit/wiki/index.php?title=Help:Getting_started

Replacing carriage-returns & line-feeds from a string/column in Oracle/Database.

To replace the carriage-returns & line-feeds from a string in Oracle or database, replace() does not work properly.

There is a special handling required to replace new line or carriage-returns.


If the data in your database is POSTED from HTML form TextArea controls, different browsers use different New Line characters:

• Firefox separates lines with CHR(10) only
• Internet Explorer separates lines with CHR(13) + CHR(10)
• Apple (pre-OSX) separates lines with CHR(13) only

So you may need something like:

• update table_name set col_name = replace(replace(col_name, CHR(13), ''), CHR(10), '') ;

- Cheers!!!

message from server: "Host is not allowed to connect to this MySQL server"

Today I came across the problem for remotely connecting to MYSQL database from an application hosted on different machine.

Solution for this issue is to run the following query for granting privileges  to desired user:

GRANT ALL PRIVILEGES ON *.* TO '<USER_NAME>'@'%' IDENTIFIED BY '<PASSWORD>' WITH GRANT OPTION;

Enjoy!!!

Productive Eclipse Plug-Ins : Easy Explorer !!!

Easy Explorer is a very useful plug in, which helps you to browse resources with the native Operating system explorer.
In the Eclipse, select a file, right-mouse click, and select the 'Easy Explore'.
This way explorer will be opened and you desired file will be highlighted.

Direct Download link for this file : Easy Explorer for Eclipse(easy-explore-1.0.4)

Likewise there is also another plug-in : StartExplorer
StartExplorer is also having lots of options, but I feel Easy Explorer is more friendly as it can be used in the tree browser as well as in editor as well.