For some reason which I don’t know why, my oracle give me that kind of error.

Googling give me for below solution. And here I post for my future reference, and also for you if you got this same problem .

Run this command first in console.

sqlplus /nolog

And after that, use these commands :

SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down
SQL> startup nomount
ORACLE instance started.
SQL> alter database mount;
SQL> alter database open;

Read the rest of this entry »

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 »

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.

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 »

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 ??