Dropping all DB tables, views, indexes, sequences in one query.

Most of the time one faces the issues like one need to delete all the tables, views, indexes or sequences in the database.
So following the query which generates DROP statements for all the components present in the Oracle database:

SELECT 'DROP TABLE ' || table_name || ';' AS statement FROM user_tables
Union
SELECT 'DROP VIEW ' || view_name || ';' AS statement from user_views
Union
SELECT 'DROP INDEX ' || index_name || ';' AS statement from user_indexes
Union
SELECT 'DROP SEQUENCE ' || sequence_name || ';' AS statement from user_sequences
Union
SELECT 'DROP SYNONYM ' || SYNONYM_name || ';' AS statement from user_SYNONYMs;

Cheers :)

Productivity Tool - PowerPro

The PowerPro software provides the user with a launch bar that is both compact and powerful. It also includes a menu and tray icon functionality. The program integrates three functionalities. It can run commands such as tool bars, tray icons, scheduler, menus, timer, mouse and hot keys. The PowerPro software can also be used by the user to close, maximize, minimize, position, roll-up to caption and tray minimize other program's windows. The program also provides utility functions. It can send keystrokes to programs, provide virtual desktops, run commands when Windows first opens, serve as a clipboard extender, can shutdown, enable keyboard macros, show all folder files in a menu, enable sounds, wallpaper and screensaver activation as well as randomization.

In practical scenarios, software professionals can use this to :

·         Add List of putties to connect to various servers and get rid of typing username password each time.
Command is as follows:
putty.exe -ssh <UserName>@<ServerIP> -pw <Password>
·         Create shortcuts to various software.
·         Create shortcuts to documentation page(so no need to open browser and then search for bookmark if done).

You can more explore about this software using following link:

·         Home Page: http://powerpro.webeddie.com/index.html
·         Feature & Configuration Demo: http://powerpro.webeddie.com/tour/index.htm

So after exploring this, you can save time and concentrate on other work :)

Cheers!!!

Keynote NF : Handy and productive tool to manage notes.

I would like to let you know about a good lightweight tool : Keynote NF

As we use notepad to save various important notes or mark some to-dos.

Due to this desktop gets messy and its trouble to find things which we have written for our simplicity :)

Using keynote one can save the important notes or any under process notes in single file.

It is having various features, I have found few of it while its usage:

• Simple to use and Lightweight – When not in use keeps running in background.
• Freeware – No licenses.
• Supports Rich Text and various feature like MS Word.
• Alarm / Reminders.
• Tree based to arrangements of notes and multiple tabs.
• Good search capabilities.
• No need to install – Unzip and start using it.

You can explore it more and I am sure you may find it handy as compared to using notepad.

Here are details about Keynote NF:

http://code.google.com/p/keynote-nf/

Keynote NF Downloads (No need to install – Unzip and Use it):

Release_1.7.8.1 (true version).rar – Size 1.76 MB

Cheers!

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.