AreJae.Com

Previously, I wrote about Automate 7 to 8 digit phone number conversion using AutoIT. Since then, I’m not using it anymore until I get a request regarding phone number conversion from my reader.

Searching that software online bring me no luck, so I ask my friend to email it to me. Now, im here to share the software in case someone need it.

You can download it here.

p/s: I’m very very busy nowdays….sorry if my response is so slow.

I always believe that I can do almost everything using AutoIt. Well, since I need to do a lot of import and export job manually, I just wondering why not I just automagically do it using AutoIt.

There are a few steps involve in this process :

1. export data from server to my local pc

2. connect to sqlplus and drop user

3. create user and grant permission

4. import back using dump file created in step 1

Now, here how I convert those steps into AutoIt.

Read the rest of this entry »

This is my first time changing my domain hosting and also transfer my arejae.com domain. Previously everything is taken care by my hosting provider.

You can read how to transfer your domain name in detail here.

Below is the first step to initiate the domain transfer. The rest, we just need to follow the instruction.

Read the rest of this entry »

If you need to drop all the triggers in oracle for a split second, here how you can do it. Below is the sample how to drop all triggers in myTesting schema with trigger name like ‘%_BI’

begin
for i in (select trigger_name,owner from dba_triggers where  trigger_name like '%_BI%' and owner = 'myTesting' ) LOOP
execute immediate 'DROP TRIGGER '||i.owner||'.'||i.trigger_name;
END LOOP;
END;

Make sure you know what you are doing.

Till then..

Happy coding...

If you are familiar with MS-SQL, you will know that you can use ISNULL function to convert NULL value to something else. In below case, it is an example how to convert NULL value to zero.

ISNULL(myField,0)

In Oracle, you can use NVL to get the same result.

NVL(myField,0)

Same thing for MySQL, you can use IFNULL to get the same result.

IFNULL(myField,0)

Don’t under estimate with this function. I’m debugging my program for almost 1 hours just to notice that some values in my Oracle tables having NULL values and causing errors while inserting to MySQL tables.

That’s my quick update for today. Till then…Happy Coding.