How to run multiple queries at once in Toad?

To run multiple queries in Toad at once follow these steps:

1. Open Toad.
2. Go to View -> Toad Options. An Options pop up window will appear.
3. In the left pane click on: Oracle -> Transactions.
4. After clicking on Transactions in the left pane, on the right pane you will see a checkbox with "Execute queries in threads (Creates separate session)" checkbox.
5. By default it is unchecked, check it and click on Apply button on bottom right. Click on OK.

Now the next time you will connect to a database instance you will be able to run separate queries in different tabs without getting the 'Statement Processing' popup.

If the above post was helpful to you then please leave a message in the comments. Thanks.

Completely remove Java from Ubuntu 14.04

There maybe many reasons why you might want to remove Java from your system. Whatever the reasons, follow the procedure below to uninstall Java from your Ubuntu system:

Remove all the Java related packages

First run the below three commands one by one to remove all Java related packages like Sun, Oracle, OpenJDK, IcedTea plugins, GIJ:

Purge config files

After removing all the packages you need to purge all the config files. For that run the following command:

Remove cache directory

After purging the config files we need to remove Java config and cache directory from your system. Run the following command to remove the cache directory:

Remove manually installed JVM's

If you have installed any other JVM's then this is the time to remove them. Run the following command:

Remove all leftover Java entries

After uninstalling all the java components from your system some java entries might still be left in your system. To get rid of them run the following command:

Remove java directories from system

This is the final step in removing Java from your system. After uninstalling the java packages the java directories might still be there in your system. To remove them you need to first find if there are any left. Use the following commands to find any leftover directories:

If after running the above script you get any output similar to 'jre1.5/bin/pack200' then run the following command (replace jre1.5 with the directory name that you got in the output at the terminal) to remove the leftover java directory:

How to embed code snippets or files from github

Gist can help you embed code from Github into any of your posts.

How to use Gist to embed code from Github:

1. Go to Github. Login into your account.
2. Go to Gist.
3. Put your code into the box (copy and paste). You can optionally add Gist Description, the language you are using and the Gist name as well.
4. Click on create Public Gist at the bottom.
5. On the next page you will get the code for embedding the Gist that you just created. Copy it and paste it where ever you want to use this Gist.

Example gist: