-
Oracle MERGE command
Oracle MERGE command was added in 9i but I only learned about it lately. This command is sometimes referred to as UPSERT because in one statement, you can both update and insert records into a target. Based on the matching condition, MERGE can update existing records if a match is found or insert new record…
-
Oracle PL/SQL Continue Statement in Loops
The CONTINUE statement is very handy feature when programming with loops in Oracle PL/SQL. Basically, it lets you skip to the next iteration of your loop (i.e., next record in the cursor loop). Unfortunately, it was only added in 11g Release 1 (11.1). This is stated in the Language Reference of that version. Below is…
-
Run SQL Script via SQL*Plus via Prompt
If you want to run an SQL script via sqlplus in the shell prompt, the command is as below. sqlplus user/pass@connect @scriptname Don’t forget that there should be an exit command at the end of the sql. Otherwise, the sqlplus will not exit and just stop running until you manually call exit. Now, if the…
-
How To Repair Ubuntu Netbook After Upgrade Problem (WUBI)
As I have posted earlier, Ubuntu upgrade broke my installation and I had to reinstall everything from scratch. And guess what, it happened again! This time, I’ve some important files in the filesystem. And since it happened the second time, it can no longer be said as an accident. Something breaks during the upgrade and…
-
How to Install Fonts in Ubuntu
Here’s a short post about installing fonts in Ubuntu. sudo cd /usr/share/fonts/ sudo cp ~/Downloads/fonts/* ./ sudo fc-cache -f -v Take note that ~/Downloads/fonts/ is the directory where my fonts are saved. I just copied it to /usr/share/fonts/ and then refresh the font cache. I hope this helps you as much it helped me.
-
Review of my 2010 Web Hosts
As the year 2010 ends, I’d like to review the hosting that I’ve been with for the year. This is the year that I started my baby steps into hosting my sites in VPS and there certainly a lot of things I learned. The purpose of this review is not to bash the companies but…
-
GCC Install Failure in Ubuntu
When I was trying to install build-essential (for gcc compiler), I keep getting a weird error that says “The HTTP server sent an invalid Content-Range header”. I’ve tried many times as I suspected it’s because of the spotty wifi connection and even tried installing via LAN to no avail. Numerous websites just say retry or…
-
Ubuntu Netbook Edition 10.10 is not for Netbooks
UNE 10.10 is sooo slow on my Asus eeePC 1002HA! On its current form, 10.10 is just not usable for me. It’s so slow and I need to tinker on settings to make things work. That’s something that put me away from migrating to linux earlier. One example is mounting of my hard disk partition…
-
Ubuntu Update Broke my Install
This is a bit of a rant rather than a tech note. As I’ve writtern on my previous post, I initially installed Ubuntu Netbook 10.04 on my ASUS eeePC 1002HA and upgraded it everytime a new version comes out via Ubuntu Software Center(easy and intuitive). So when the last update came out the other week,…
-
Shopping Cart Always Empty
After using suPHP on my Apache webserver and NGINX on another server, I realized that my cart systems are no longer working. Here are the symptoms I noticed. AJAX Carts does not display items When clicking checkout, the cart becomes empty After clicking update, the cart becomes empty If you look at the symptoms, you’ll…
Recent Comments