Never regret.

If it’s good, it’s wonderful

If it’s bad, it’s experience

p/s : who feel time is running too fast…?

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