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:

	sudo apt-get update
	apt-cache search java | awk '{print($1)}' | grep -E -e '^(ia32-)?(sun|oracle)-java' -e '^openjdk-' -e '^icedtea' -e '^(default|gcj)-j(re|dk)' -e '^gcj-(.*)-j(re|dk)' -e 'java-common' | xargs sudo apt-get -y remove
	sudo apt-get -y autoremove

view raw RemoveJava1 hosted with ❤ by GitHub

Purge config files

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

dpkg -l | grep ^rc | awk '{print($2)}' | xargs sudo apt-get -y purge

view raw RemoveJava2 hosted with ❤ by GitHub

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:

sudo bash -c 'ls -d /home/*/.java' | xargs sudo rm -rf

view raw RemoveJava3 hosted with ❤ by GitHub

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:

sudo rm -rf /usr/lib/jvm/*

view raw RemoveJava4 hosted with ❤ by GitHub

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:

for g in ControlPanel java java_vm javaws jcontrol jexec keytool mozilla-javaplugin.so orbd pack200 policytool rmid rmiregistry servertool tnameserv unpack200 appletviewer apt extcheck HtmlConverter idlj jar jarsigner javac javadoc javah javap jconsole jdb jhat jinfo jmap jps jrunscript jsadebugd jstack jstat jstatd native2ascii rmic schemagen serialver wsgen wsimport xjc xulrunner-1.9-javaplugin.so; do sudo update-alternatives --remove-all $g; done

view raw RemoveJava5 hosted with ❤ by GitHub

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:

	sudo updatedb
	sudo locate -b '\pack200'

view raw RemoveJava5 hosted with ❤ by GitHub

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:

sudo rm -rf /path/to/jre1.5

view raw RemoveJava6 hosted with ❤ by GitHub

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:

This is a Gist example code.

view raw exampleGist hosted with ❤ by GitHub