As of Oracle 11 you can use the REGEXP_COUNT function to count the number of occurrences of a word or string in a varchar. However, if you’re using Oracle 10 you may be able to achieve something similar as shown below. In this example we count how many times the word ‘two’ appears in...
Read more →If you need to automatically start/stop Tomcat each time you start/stop/reboot your Linux server, you can do so by creating a start/stop script under the /etc/init.d directory. The sample script below is called /etc/init.d/tomcat and runs Tomcat as a user called “tomcat” – because most likely you do not want Tomcat to run as...
Read more →By default, Ubuntu uses DHCP in order to get an IP address. If you need a static IP instead, you need to update your interface configuration. This is done in file /etc/network/interfaces By default, the contents of this file will probably look similar to this: Most likely, your main interface will be eth0 (or...
Read more →If you need to recover files and/or partitions on Linux, TestDisk and PhotoRec may be useful. Both are very powerful and free tools that run on Linux and may also work if you need to recover data from USB Hard Drives, USB Memory Drives, Memory Cards, CD-ROMS, iPod, etc. Despite its name “PhotoRec”, this...
Read more →Unlike on the Ubuntu Desktop edition, USB devices are not automatically mounted on Ubuntu Server. You will have to do it manually. Luckily it’s quite simple. First, you need to find out which device needs to be mounted: sudo fdisk -l Most likely, your USB Hard Drive will be /dev/sdb1. Now we create a...
Read more →