In MySQL, we can easily drop table and check whether it is exist or not using this statement.
DROP TABLE IF EXISTS MyTable
In Oracle, you can’t do that.
Solution that I found is to create a procedure and execute it.
As for my reference and others (if any) here is the script to create that procedure.
Read the rest of this entry »
March 2nd, 2010 | Posted in Database, Tips & Tricks | No Comments
Testing first blog post using BlackBerry with bbMetaBlog. You can download it here .
p/s: This post has been edited by blogdesk since I’m having problem editing it using bbMetaBlog.
February 21st, 2010 | Posted in :Else: | No Comments
VCF or vCard file is a file format standard for electronic business card. Below are the way how I used to export it to my BlackBerry.
1. Combine all the vcf file into one file. If you are in windows environment you can use below command. Make sure your working directory is correct.
type * > all_contacts.vcf
2. Download and install ABC Amber vCard converter. This software can convert vcf file to ipd file which is recognized by BlackBerry. Click BlackBerry icon to convert the selected contact.

Read the rest of this entry »
February 19th, 2010 | Posted in BlackBerry, Tips & Tricks | No Comments
After following some of the BlackBerry developer tutorials here and here, I finally manage to run my first BlackBerry application. It’s cool.
Here is my BlackBerry screenshot taken by CaptureIt

Why develop for BlackBerry ??

February 16th, 2010 | Posted in Programming | No Comments
For whatever reason, sometimes you will need to change your SVN URL. Perhaps you need to place the server to a new building and change the ip address. After the changes, you cannot commit to that server using your eclipse.
To solve the problem, you can relocate your SVN server and change to the new URL. Look at the image below and you will know that it’s very easy
Open up SVN Repositories perspective in eclipse.

Read the rest of this entry »
February 8th, 2010 | Posted in Programming, Tips & Tricks | No Comments