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..
Topics: AutoIt, My Life

{"title":"HR2000 Telekom 8 Digit Converter.","post_url":"http:\/\/www.arejae.com\/blog\/hr2000-telekom-8-digit-converter.html","feed_url":"http:\/\/www.arejae.com\/myweblog\/feed\/","author":null,"date":"2009-05-07 19:47:21","summary":"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.."}

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...
Topics: AutoIt, Programming

{"title":"Automate your oracle import and export using AutoIt","post_url":"http:\/\/www.arejae.com\/blog\/automate-your-oracle-import-and-export-using-autoit.html","feed_url":"http:\/\/www.arejae.com\/myweblog\/feed\/","author":null,"date":"2009-03-25 04:50:43","summary":"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..."}

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

{"title":"Domain Transfer and New Hosting","post_url":"http:\/\/www.arejae.com\/blog\/domain-transfer-and-new-hosting.html","feed_url":"http:\/\/www.arejae.com\/myweblog\/feed\/","author":null,"date":"2009-03-21 07:55:10","summary":"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..."}

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’beginfor i in (select trigger_name,owner from...
Topics: SQL/ETL

{"title":"Drop all triggers in Oracle","post_url":"http:\/\/www.arejae.com\/blog\/drop-all-triggers-in-oracle.html","feed_url":"http:\/\/www.arejae.com\/myweblog\/feed\/","author":null,"date":"2009-03-20 04:34:47","summary":"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’beginfor i in (select trigger_name,owner from..."}

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...
Topics: Database, SQL/ETL

{"title":"Check for NULL Value in Oracle and MySQL","post_url":"http:\/\/www.arejae.com\/blog\/check-for-null-value-in-oracle-and-mysql.html","feed_url":"http:\/\/www.arejae.com\/myweblog\/feed\/","author":null,"date":"2009-03-04 19:24:13","summary":"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..."}